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
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).