SQL>select id from tab1; ID ---------- 1 2 3 SQL>select id from tab2; ID ---------- 2 3 4 SQL> SQL>select tab1.id,tab2.id from tab1,tab2 where tab1.id=tab2.id; ID ID ---------- ---------- 22 33 SQL>select tab1.id,tab2.id from tab1,tab2 where tab1.id(+)=tab2.id; ID ID ---------- ---------- 22 33 4 SQL>select tab1.id,tab2.id from tab1,tab2 where tab1.id=tab2.id(+); ID ID ---------- ---------- 1 22 33