>Sergey,
>
>Are you telling me "No" it can't be done, or it can't be done the way I currently have my statement?
>
>You say I should move my condtions from the WHERE tot he JOIN(s), does that mean I have specify my criteria in each join condition along with the join condition like so:
>
>

>..... full join dga d on d.custid=l.custid and d.upsino = l.upsino and d.puldat=l.puldat and d.custid="SC100234 and d.upsino="0000004"
>..... full join icp i on i.custid=d.custid and i.upsino=d.upsino and i.puldat=d.puldat and i.custid="SC100234" and i.upsino="0000004"
>..... full join furanppm f on f.custid=d.custid and f.upsino=d.upsino and f.puldat=d.puldat and f.custid="SC100234" and f.upsino="0000004"
>
>

>
>

Yes. Otherwise you'll end up with the INNER JOIN.