Re: a join question

This is table1
code1 code2 code3
--------- -------- ---------
9 8 7
This is table2;
Code Description

---------    ----------------
9            Nine
8            Eight
7            Seven

SELECT
T1.code1,T21.description,T1.code2,T22.description,T1.code3,T23.description FROM table1 T1,

       table2 T21,
       table2 T22,
       table2 T23
where
       T1.code1=T21.code AND T1.code1=T22.code AND T1.code1=T23.code

that works correct
but when there is empty codeX field in Table1 , no row returns because there is no match found in table2 is there any way to fix that? Received on Tue Jan 24 2006 - 08:14:31 CST