Introduction to SQL Joins

Write an Inner Join Query

Write a SQL query to find all employees and their departments using an Inner Join between Employees and Departments tables.

Expected output: A list of employees with their corresponding department names.

Hint: Join on the department ID column common to both tables.

Compare Left and Right Joins

Write queries using Left Join and Right Join on two tables and observe the differences in results.

Expected output: Two result sets showing how Left and Right Joins differ.

Hint: Use the same join condition but switch the table order.

INNER JOIN returns only rows with matching values in both tables, while LEFT JOIN returns all rows from the left table and matched rows from the right table, filling with NULLs when there is no match.

Yes, SQL allows joining multiple tables by chaining JOIN clauses with appropriate join conditions.

Omitting the ON clause causes a Cartesian product, returning all combinations of rows from the joined tables, which is usually undesirable.