From StackOverflow
<join_type> ::=
[ { INNER | { { LEFT | RIGHT | FULL } [ OUTER ] } } [ <join_hint> ] ]
JOIN
- If you just mention
JOIN
then by default it is aINNER JOIN
. - An
OUTER
join has to beLEFT | RIGHT | FULL
you can not simply sayOUTER JOIN
. - You can drop
OUTER
keyword and just sayLEFT JOIN
orRIGHT JOIN
orFULL JOIN
.