Nope. I get 5 versions of one of the records in sowgts and none from the other 2.

Thanks,

Michelle



>Try an Inner Join. This will give you only matching records.
>
>>I'm trying to figure out what kind of joins to use here.
>>
>>

>>   FROM sowgts ;
>>       ????? JOIN soskid ON sowgts.skidkey = soskid.skidkey ;
>>       ????? JOIN somast ON sowgts.sono = somast.sono  ;
>>       ????? JOIN sotran ON somast.sono = sotran.sono ;
>>       ????? JOIN arcust ON sotran.custno = arcust.custno ;
>>       ????? JOIN soaddr ON somast.sono = soaddr.sono ;
>>       ????? JOIN highskid ON soskid.bolno = highskid.bolno ;
>>       ????? JOIN netwts ON soskid.skidkey = netwts.skidkey
>>

>>
>>For each record in sowgts, I want one record in the final product. I tried all LEFT OUTERs, but I ended up with a bunch of records. What kind of joins should I use to get one record?
>>
>>Thanks,
>>
>>Michelle