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 2
D)SELECT column-list FROM table1 LEFT table2 [JOIN]
WHERE join-condition

Question

Quizplus · Accepted Answer

The syntax for a left outer join involves using the LEFT JOIN keyword, followed by the table names and the ON keyword to specify the join condition. The optional OUTER keyword can also be used. Therefore, option B is the correct syntax for a left outer join. Option A has an incorrect keyword "OUTER" before the "LEFT" keyword. Option C uses an incorrect syntax and lacks the JOIN keyword. Option D has an improper order of keywords used.

The Syntax for a Left Outer Join Is