The syntax for a left outer join is _____.
A) SELECT     column-list
FROM        table1 OUTER JOIN table2 LEFT
WHERE     join-condition
B) SELECT     column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition
C) SELECT     column-list
WHERE     LEFT table1 = table
D) SELECT    column-list
FROM       table1 LEFT table2 [JOIN]
WHERE     join-condition

Question

The syntax for a left outer join is _____.
A) SELECT     column-list
FROM        table1 OUTER JOIN table2 LEFT
WHERE     join-condition
B) SELECT     column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition
C) SELECT     column-list
WHERE     LEFT table1 = table
D) SELECT    column-list
FROM       table1 LEFT table2 [JOIN]
WHERE     join-condition

Quizplus · Accepted Answer

The syntax for a left outer join involves using the LEFT JOIN keywords followed by the table names and the ON clause specifying the join condition. The OUTER keyword is optional and the SELECT clause then lists the columns to be retrieved from the resulting joined table. Therefore, option B is the correct syntax for a left outer join.

The Syntax for a Left Outer Join Is _____