code_junkie

Oracle join operator

Nov 12th, 2011
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. select tab1.id, tab2.id, tab3.id
  2. from tab1, tab2, tab3
  3. where tab1.col1 = tab2.col1(+) and tab2.col2 = tab3.col2(+);
  4.  
  5. select tab1.id, tab2.id, tab3.id
  6. from tab1
  7. left outer join tab2 on tab1.col1 = tab2.col1
  8. left outer join tab3 on tab2.col2 = tab3.col2;
Add Comment
Please, Sign In to add comment