Yes, that's what I want.

Thanks,

Michelle


>LEFT OUTER will give the records in the sowgts table even if they don't have a match in some of the other tables. If this is what you want, LEFT OUTER is ok.
>
>Vlad
>
>>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?