JOIN in SQL |||| SQL Tutorial for beginners in Tamil
The SQL JOIN statement is used to combine rows from two tables based on a common column and selects records that have matching values in these columns
-- join the Customers and Orders tables
-- based on the common values of their customer_id columns
SELECT Customers.customer_id, Customers.first_name, Orders.item
FROM Customers
JOIN Orders
ON Customers.customer_id = Orders.customer_id;