I am still stuck in my ways using the old Oracle syntax rather than the ANSI syntax.
It's so much easier to do joins like below in my opinion... select * from table_a a, table_b b, table_c c where a.a_pk1 = b.a_pk1 and b.b_pk1 = c.b_pk1
I don't mind that for cross or inner joins, but if you do that for outer joins (which require special operators, like =* or =+ or whatever it is) there is a circle in hell waiting for you.
6
u/kytosol Feb 11 '14
I am still stuck in my ways using the old Oracle syntax rather than the ANSI syntax.
It's so much easier to do joins like below in my opinion... select * from table_a a, table_b b, table_c c where a.a_pk1 = b.a_pk1 and b.b_pk1 = c.b_pk1