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.skidkeyFor 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?