Re: Left Join more than one table

2002-11-27 Thread Roger Baklund
* vinita vigine Murugiah > I'm using ver 3:23:49 & 3:23:53, I thought > "A LEFT JOIN B USING (c)" is Identical to "A LEFT JOIN B ON A.c = B.c" I think it is... > It seems it is NOT the case if you are joining more that ONE table & one > of them is EMPTY. Please see the following Example [...

Left Join more than one table

2002-11-26 Thread vinita vigine Murugiah
HI I'm using ver 3:23:49 & 3:23:53, I thought "A LEFT JOIN B USING (c)" is Identical to "A LEFT JOIN B ON A.c = B.c" It seems it is NOT the case if you are joining more that ONE table & one of them is EMPTY. Please see the following Example mysql> select * from room; +-+-