How do I use JOIN in SQL?

How do I use JOIN in SQL?

JOIN in SQL is used to combine rows from two or more tables based on a related column. What specific type of JOIN are you interested in?

Can you explain the difference between INNER JOIN and LEFT JOIN?

Sure! INNER JOIN returns only the rows that have matching values in both tables, while LEFT JOIN returns all rows from the left table and the matched rows from the right table. If there's no match, NULL values are returned for columns from the right table.

Can you give me an example of an INNER JOIN?

Absolutely! Here's a simple example: SELECT employees.name, departments.name FROM employees INNER JOIN departments ON employees.department_id = departments.id; This will return names of employees along with their respective department names.

What about using multiple JOINs in a single query?

You can use multiple JOINs by chaining them together. For example: SELECT a.name, b.order_id, c.product_name FROM customers a INNER JOIN orders b ON a.id = b.customer_id INNER JOIN products c ON b.product_id = c.id; This retrieves customer names, their order IDs, and product names.