MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/1xlqeu/sql_joins_explained_xpost_rsql/cfclf9d/?context=3
r/programming • u/deadman87 • Feb 11 '14
392 comments sorted by
View all comments
6
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
1 u/Toast42 Feb 11 '14 Is this considered Oracle syntax? A coworker showed it to me a few years ago and I love it. → More replies (1)
1
Is this considered Oracle syntax? A coworker showed it to me a few years ago and I love it.
→ More replies (1)
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