Re: How to limit rows read to 1 rows

[Michael Ryan <michaelrtr@xxxxxxxxx>]

you can do something like this...

Exec SQL
  Select SCVNDA, SCMDL Into :WkSetFirstChildVnda, :WkSetFirst
    From InvSxrP
  Where SSVNDA = :WkVnda And
        SSMDL = :WkMdl
  Order By SCSEQ#
  Fetch First Row Only;

On Fri, Jan 7, 2011 at 12:36 PM, Darryl Freinkel
<dfreinkel@xxxxxxxxxxxxxxxxx> wrote:
> I have a SELECT statement that returns more than 1 record for a invoice. The
> file can have 1 to many invoice records with the same invoice number.
>
>
>
> I need a way to limit the select, to read only one of those invoice records.
>
>
>
> There is a solution using LIMIT, but I cannot get that to work.
>
>
>
> Example:
>
>
>
> Select * from table1 T1 where T1.INVOICE in
>
> (Select T2.Invoice from table2 T2 where T1.Invoice = T2.invoice LIMIT 1)
>
>
>
> TIA
>
>
>
> Darryl Freinkel
>
>
>
> --
> 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.