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?