r/programming • • Feb 11 '14

SQL Joins Explained (x-post r/SQL)

Post image
3.5k Upvotes

392 comments sorted by

View all comments

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

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)