If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.
A) OF
B) USING
C) HAS
D) JOIN ON

Question

Quizplus · Accepted Answer

The JOIN ON clause is used to specify the join condition between two tables even if they do not have a commonly named attribute. Using this clause, the designer can specify the column names to join on, regardless of what they are named in the tables. The other options, such as OF or HAS, are not valid SQL join clauses. The USING clause is used to specify a join condition when the two tables have a commonly named attribute.

If a Designer Wishes to Create an Inner Join, but the Two