The command used in an SQL query to combine fields from several tables is
A) GROUP BY.
B) ORDER BY.
C) WHERE INSTR.
D) INNER JOIN.

Question

Quizplus · Accepted Answer

INNER JOIN is the command used in an SQL query to combine fields from several tables. It allows us to match records between two or more tables based on a related column between them. This is helpful in querying data that is spread across multiple tables. The other options, GROUP BY, ORDER BY, and WHERE INSTR, are used for other purposes such as grouping data, sorting data, and searching for a specific substring within a string respectively.

The Command Used in an SQL Query to Combine Fields