SQL Question

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

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
+---