
Using OUTER , WHERE or Simply JOIN
Question: Does it make a difference in placing an OUTER or simply a JOIN or a WHERE? Using WHERE: select tb01_field01,tbl01_field02 from tb01,tb02 where tb01_field01 = tb02_field01 Using JOIN: SELECT TB01_FIELD01,TB01_FIELD02 FROM TB01 JOIN TB02 ON TB01_FIELD01 = TB02_FIELD01 How do I use OUTER to do the same thing as