Question

In an SQL query, which SQL keyword is used to specify the names of tables to be joined?

a) FROM
b) HAVING
c) JOIN
d) SELECT
e) WHERE

Answer 1

The SQL keyword used to specify the names of tables to be joined is 'JOIN'. It is part of the SQL statement that combines rows from two or more tables based on a related column.

Step-by-step explanation:

You asked which SQL keyword is used to specify the names of tables to be joined in an SQL query. The correct answer is c) JOIN. The JOIN clause is used in SQL to combine rows from two or more tables, based on a related column between them. The most common types of joins are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

To use a JOIN, you need to specify it in your SQL statement after the FROM clause. Here's a simple example of using JOIN:

SELECT table1.column1, table2.column2
FROM table1
JOIN table2
ON table1.common_column = table2.common_column;

This query selects columns from two tables and joins them using a common column.