Question

In an SQL query, how is a join operation achieved?

1) By specifying the equality of the respective column names as a condition in the WHERE clause.
2) By using the GROUP BY clause.
3) By using the ORDER BY clause.
4) By using the HAVING clause.

Answer 1

In an SQL query, a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.

Step-by-step explanation:

In an SQL query, a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause. This is done by using the JOIN keyword followed by the name of the table to join and the ON keyword to specify the equality condition.

Example:

SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
JOIN Customers
ON Orders.CustomerID = Customers.CustomerID;

This query joins the Orders table with the Customers table on the condition that the CustomerID column in Orders is equal to the CustomerID column in Customers.