Re: TOP 1

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

    FETCH FIRST 1 ROW ONLY is the way. I dont use group by because am using
a logical that is  order by order#

On Tue, Jun 16, 2015 at 10:14 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

>  Charles, Fetch first row only
>
> On Tue, Jun 16, 2015 at 10:07 AM, Paul Nelson <nelsonp@xxxxxxxxxxxxx>
> wrote:
>
> > *SPENDMONEY would be an appropriate parameter for your employer to use.
> >
> > Paul Nelson
> > Cell 708-670-6978
> > Office 409-267-4027
> > nelsonp@xxxxxxxxxxxxx
> >
> >
> > -----Original Message-----
> > From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> > Hoteltravelfundotcom
> > Sent: Tuesday, June 16, 2015 8:35 AM
> > To: Midrange Systems Technical Discussion
> > Subject: TOP 1
> >
> > HI I have one table with all orders info and other table has the shipping
> > info. I only need to 'chain' one
> > row from the shipping table to get the ship via method. But its multi rows
> > so I trued top1
> > its not compiling. how to read just the first row in sql on the i. I tried
> > top1, topn nothing is compiling.
> > (
> > SELECT TOP 1
> >     STDTA.pshipll1.phviac
> >
> > FROM
> >     STDTA.pshipll1
> > WHERE
> >         "SHPWEIGHT"."IDORD#" = STDTA.pshipll1.phord#
> > )
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.