Ther's no good reason to use RIGHT join in the first place.
>
>Can anyone tell me why the following RIGHT OUTER JOIN statement returns the same records as an INNER JOIN?
>
>SELECT v.custid, l.custid, v.upsino, l.upsino, v.datinp, l.puldat, v.optemp, v.pktemp, l.ift, l.color;
>FROM visual v ;
>RIGHT OUTER JOIN liquid l ;
>ON v.custid + v.upsino + DTOS(v.datinp) = l.custid + l.upsino + DTOS(l.puldat) ;
>WHERE v.custid = "AL100239" AND v.upsino = "0000001";
>ORDER BY v.upsino, v.datinp
>
>I have records in the liquid table that have a UPSINO = "0000001" with a puldat that has NO MATCHING datinp record in the VISUAL table. Why do these records not show up in the results with the non matching fields set to NULL.
>
>I am trying extract all records from the LIQUID table that match my lookup criteria whether on not they have a matching record in VISUAL.
>
>
>Thank you.
--sb--