In the example 'SELECT column1 FROM table JOIN table2 ON table.column1 = table2.column1', what operation is being performed?

• A. Selecting columns from a single table only.
• B. Deleting rows from both tables.
• C. Joining two tables on a related column to combine rows.
• D. Sorting results by a column.

Answer: (C)

The operation is about combining data from two tables based on a shared relationship. The query references two tables and uses an ON clause that ties table.column1 to table2.column1, so rows with matching values in that column are joined together. This merges related rows from both tables into one result row, effectively bringing together information from the two sources. Because no outer-join type is specified, this behaves as an inner join by default, returning only rows where there’s a match in both tables. It isn’t just selecting from a single table, deleting data, or sorting results; the core action is linking related rows from the two tables through the join condition. The SELECT clause determines which column(s) to display, and in this example it shows column1.