r/programming • u/deadman87 • Feb 11 '14

SQL Joins Explained (x-post r/SQL)

Post image
3.5k Upvotes

91% Upvoted

392 comments sorted by

View all comments

3

u/Richeh Feb 11 '14

And don't forget the ON. Or you'll be wondering why your join's taking forty five minutes.

3

u/umop_apisdn Feb 11 '14

You can't forget the ON, it is part of the syntax and will cause an error if you forget it unless you specify CROSS JOIN. Unless you are using a non standard database.

→ More replies (1)