If you are attempting to join two tables that have multiple common columns,which of the following JOIN keywords should be used to specify how the tables should be linked?
A) OUTER JOIN
B) CROSS JOIN
C) JOIN...USING
D) none of the above

Question

If you are attempting to join two tables that have multiple common columns,which of the following JOIN keywords should be used to specify how the tables should be linked?​
A) ​OUTER JOIN
B) ​CROSS JOIN
C) ​JOIN...USING
D) ​none of the above

Quizplus · Accepted Answer

The JOIN...USING keyword should be used to specify the common columns to join the tables on. This keyword determines the columns on which the join is based and eliminates the repetition of columns that would result from a normal JOIN. OUTER JOIN and CROSS JOIN do not specify the common columns to be used for joining.

If You Are Attempting to Join Two Tables That Have