CODEWITHSUNDEEP
sqlleft-joinouter-joinansi-sql
ManiP
ManiP

Reputation: 733

'LEFT JOIN' vs 'LEFT OUTER JOIN'

I know there is really no difference, but is 'LEFT JOIN' an ANSI form or are there any RDBMS's that will fail 'LEFT JOIN' and require 'LEFT OUTER JOIN'. [I am asking here so I can save a few clicks, form fillings, etc to get the correct ANSI standard!]

Upvotes: 7

Views: 8979

Answers (2)

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239636

[OUTER] is optional, per the ANSI spec (92, but I'm sure later versions also cover it).

Of course, you're assuming that every SQL product is ANSI compatible. For joins, they probably are..

Upvotes: 17

Carlos Quintanilla
Carlos Quintanilla

Reputation: 13303

ANSI JOINS

http://www.oratechinfo.co.uk/ansi_joins.html

Note, the OUTER can be dropped, since, by definition, LEFT, RIGHT and FULL JOINs MUST be OUTER joins (it's down to personal preference and readability)

Upvotes: 3

Related Questions