Question

In an SQL query, which SQL keyword is used to specify the condition(s) for a join operation?

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

Answer 1

The JOIN keyword is used to specify the condition(s) for a join operation in an SQL query.

Step-by-step explanation:

In an SQL query, the JOIN keyword is used to specify the condition(s) for a join operation. The JOIN keyword is used to combine rows from two or more tables based on a related column between them. It allows you to retrieve data from multiple tables based on a specific condition.