Sergey,

I understand that the LEFT JOIN is including all records from VISUAL that meet the criteria and only those records in the other tables that meet the join conditions. Here's my issue though, I may have records in the other tables that have a PULDAT that is unique to that table. For example, I have a single test result in the FURANPPM table with a PULDAT of 10/28/2002. This is the only record with that puldat. It doesn't exist in any other tables including the visual, but I want it included in my results.

How do I ensure I get ALL records regardless of PULDAT and still match-up those records that have same PULDATs. Do I need to add several OR clauses to my WHERE clause as in ...

   WHERE v.custid = "SC100234" and v.upsino = "0000004" ;
   OR l.custid = "SC100234" and l.upsino = "0000004" ;
   OR d.custid = "SC100234" and l.upsino = "0000004" ;
   OR i.custid = "SC100234" and l.upsino = "0000004" ;
   OR f.custid = "SC100234" and l.upsino = "0000004" ;

>You'll get records from visual regardless if there're releted records in other tables.You may want to wrap fields from othe rtables in NVL() to aboid nulls. You don't have to change WHERE claus ebecause it references only fields from the 'visual' table.
>

>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 visual v ;
>	LEFT JOIN liquid l on l.custid = v.custid and l.upsino = v.upsino and v.datinp = l.puldat ;
>	LEFT JOIN dga d on d.custid = l.custid and d.upsino = l.upsino and d.puldat = l.puldat ;
>	LEFT JOIN icp i on i.custid = d.custid and i.upsino = d.upsino and i.puldat = d.puldat ;
>	LEFT JOIN furanppm f on f.custid = d.custid and f.upsino = d.upsino and f.puldat = d.puldat ;
>	WHERE v.custid = "SC100234" and v.upsino = "0000004" ;
>	order by v.upsino, v.datinp
>

>>
>>I thought I'm using FULL JOIN because I thought I had in order to retrieve all records from both tables if they meet the filter criteria.
>>
>>Both you and Tamar tell me I have to put what I have in my WHERE clause into the JOIN condition. How do I do that? Do I put the filter criteria in each and every join?
>>
>>Can you copy and paste my earlier code here and tell me what I'm doing wrong?
>>