but below code is more beautiful :)
select * from T1, T2 where T1.C1 = T2.C1(+) and T1.C2(+) = ‘Y’;
also U may use something
select * from T1 left outer join T2 on (T1.C1 = T2.C1 and T1.C2 = ‘Y’)
but in plus notation it's more complex
select * from T1 left outer join T2 on (T1.C1 = T2.C1 and substr(T1.C2,10,20) = ‘Y’)
Fran wrote:I dont want to join using a select ! . I'll just pick all records from Table A . That's the point I'm making
no, it can't.
if you try a "SELECT" you only can join two tables with fiels matched.
If you use "LEFT JOIN" you can join two tables, full left table and fiels matched on right table.I agree. But are not they giving the same result ? both are giving FULL Table A records.
yeah, If you want only results only from table A you dont need any JOIN.