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"

>No, the records that do not have related record in the 'visual' table are filtered out by WHERE clause.
>

>where v.custid = "SC100234" and v.upsino = "0000004" ;
>

>You've to move conditions from WHERE into related JOIN(s)
>
>>
>>I want to join various fields from six tables with one SELECT statement. Can that be done?
>>
>>I need it to be a full join because I need all records from all tables that match my criteria. I have started a SELECT statement with five of the six tables as shown below. I think I need to use the FORCE keyword here to control the join evauluation, do I not?
>>
>>In the results I am looking at now a record in the "furanppm" table is being excluded that should be there. I have checked this record and I can't find a record in any of the other tables that match its date. Could that be why it is not included? I thought the FULL JOIN would handld that and that means to bring it into the result set regardless.
>>
>>Here's my current work:
>>
>>

>>select v.custid, v.upsino, v.datinp, v.optemp, v.pktemp, ;
>>	   l.dielectric, l.neut_no, l.ift, l.h20, ;
>>	   d.hydrogen, d.methane, d.ethylene, ;
>>	   i.aluminum, i.copper, i.iron, ;
>>	   f.hydroxymth, f.furfuryl, f.furaldehyd ;
>>	   from force visual v ;
>>	   full join (liquid l full join dga d on d.custid = l.custid and d.upsino = l.upsino and d.puldat = l.puldat ;
>>	   full join icp i on i.custid = d.custid and i.upsino = d.upsino and i.puldat = d.puldat ;
>>	   full join furanppm f on f.custid = d.custid and f.upsino = d.upsino and f.puldat = d.puldat) on ;
>>	   l.custid = v.custid and l.upsino = v.upsino and v.datinp = l.puldat ;
>>	   where v.custid = "SC100234" and v.upsino = "0000004" ;
>>	   order by v.upsino, v.datinp
>>

>>
>>Thanks a million.