When joining tables, the _________ clause specifies the columns from each table that are compared to determine which rows are merged.
A) ON
B) WHERE
C) LIKE
D) GROUP

Question

Quizplus · Accepted Answer

The ON clause is used in SQL to specify the columns from each table that are compared to determine which rows are merged in a JOIN operation. The WHERE clause is used to filter rows after the tables are joined. The LIKE clause is used to compare strings for a pattern match. The GROUP BY clause is used to group rows based on a specified column or expression.

When Joining Tables, the _________ Clause Specifies the Columns from Each