If there is only one match in all the child tables, then a INNER JOIN should get you only one record per record in sowgts.

>First match? There's only 1 match, so I don't know where first comes into it.
>
>Each record in sowgts has
>* a skid in soskid
>* a sales order in somast
>* a line item in sotran
>* a customer in arcust
>* an address in soaddr
>* a highest numbered skid in highskid
>* a net weight in netwts
>
>I just want to put all of this info into the same record. What would I group by? There's no groups?