Thursday, December 16, 2010

Oracle: OUTER JOIN operator

Just to note that (+) means an OUTER JOIN.

Example :
select a2 from table_a,table_b where table_a.a1=table_b.b1 (+) and table_b.b1=999999

No comments: