Your welcome. I sent you an email.

>Ok, I figured it out. I was right in the first place with using all LEFT OUTER JOINs. The problem was that I only had one part of a two part key on sotran.
>
>Thanks, both of you.
>
>Michelle
>
>
>
>
>
>>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?