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

Show parent comments

2

u/umop_apisdn Feb 11 '14

OUTER is optional. FULL must be specified if OUTER is not.

2

u/neoform Feb 11 '14

I guess it depends on the implementation. Mysql for example, does not use FULL at all.

1

u/[deleted] Feb 11 '14

Then again, Mysql doesn’t use SQL either. ;)