From clause outer join

The syntax for the FROM clause with OUTER JOIN in BNF is as follows:

Syntax

from_clause_outer_join ::=
FROM table_ref LEFT OUTER JOIN table_ref  ON search_condition