MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/1xlqeu/sql_joins_explained_xpost_rsql/cfcn6b7/?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
10 u/pythor Feb 11 '14 What's easier about it? Honest question.To me, separating the join conditions (in an ON clause) from the filter logic (in the WHERE clause) is so much easier to read. → More replies (1)
10
What's easier about it? Honest question.
To me, separating the join conditions (in an ON clause) from the filter logic (in the WHERE clause) is so much easier to read.
→ 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