RE: SQL Question

[Joe Teff <JoeTeff@xxxxxxxxxxxxx>]

I tried some tricks on my AS/400 but was unable to get around a join or
subselect to do it. I'm thinking this is not possible in SQL. I will show
this to some of our VB developers tomorrow to see if they have any ideas.

Joe Teff

----------
From:   Stone, Brad V (TC)[SMTP:bvstone@taylorcorp.com]
Reply To:       MIDRANGE-L@midrange.com
Sent:   Thursday, June 29, 2000 2:08 PM
To:     'MIDRANGE-L@midrange.com'
Subject:        SQL Question

Question on SQL...

I have an order detail file.  The unique key is invoice number, sequence
number.  I want to only select records that are the first sequence number
for each invoice.

I've been playing, but I can't figure it out.  Something like (not
syntatically correct)

select * from orddetpf where odcst = '36000' 
order by odinv 
but only select min(seqno) group by invoice

I'd like to do it with a single select (no subquery) if possible.  This is
because I have an option for a user to either view all detail lines, or only
the first one of each order.  I already have the SQL statment for the first,
and would like to just modify it (dynamic SQL) depending on which "mode" the 
user chooses.

Thanks!
Brad
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---