A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?
A) NATURAL JOIN
B) JOIN...ON
C) LEFT OUTER JOIN
D) FULL OUTER JOIN

Question

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?​
A) ​NATURAL JOIN
B) ​JOIN...ON
C) ​LEFT OUTER JOIN
D) ​FULL OUTER JOIN

Quizplus · Accepted Answer

When using a NATURAL JOIN to join tables, the join condition is implicitly based on all columns with the same name in both tables. Therefore, it does not allow an alias to be assigned in the FROM clause.

A Table Alias Cannot Be Assigned in the FROM Clause