-- 1. INNER JOIN
SELECT e.name, d.dept_name
FROM Employees e
INNER JOIN Departments d
ON e.dept_id = d.dept_id;
-- 2. LEFT JOIN
SELECT e.name, d.dept_name
FROM Employees e
LEFT JOIN Departments d
ON e.dept_id = d.dept_id;
-- 3. LEFT OUTER JOIN
SELECT e.name, d.dept_name
FROM Employees e
LEFT OUTER JOIN Departments d
ON e.dept_id = d.dept_id;
-- 4. RIGHT JOIN
SELECT e.name, d.dept_name
FROM Employees e
RIGHT JOIN Departments d
ON e.dept_id = d.dept_id;
-- 5. RIGHT OUTER JOIN
SELECT e.name, d.dept_name
FROM Employees e
RIGHT OUTER JOIN Departments d
ON e.dept_id = d.dept_id;
-- 6. FULL OUTER JOIN
SELECT e.name, d.dept_name
FROM Employees e
FULL OUTER JOIN Departments d
ON e.dept_id = d.dept_id;
-- 7. CROSS JOIN
SELECT e.name, d.dept_name
FROM Employees e
CROSS JOIN Departments d;