LEFT OUTER JOIN is expressed as just LEFT JOIN in MySql syntax?

left-join, mysql, sql, syntax

Solution

Basically they are the same.

`LEFT` and `RIGHT` are `outer` type join. The keyword `OUTER` is optional, and what this means in this case is that whether you specify it or not makes no difference.

Additional Information,

At the top level there are mainly 3 types of joins:

- INNER

- OUTER (LEFT, RIGHT)

- CROSS

Problem

Original source