Untitled

create database company1;
use company1;
CREATE TABLE employees (
 id INT PRIMARY KEY,
 name VARCHAR(100),
 department_id INT
);
CREATE TABLE departments (
 department_id INT PRIMARY KEY,
 department_name VARCHAR(100)
);
-- Insert data into employees table
INSERT INTO employees (id, name, department_id)
VALUES
(1, 'Alice', 1),
(2, 'Bob', 2),
(3, 'Charlie', 1),
(4, 'David', 3),
(5, 'eve', 5);
-- Insert data into departments table
INSERT INTO departments (department_id, department_name)
VALUES
(1, 'HR'),
(2, 'Finance'),
(3, 'IT');


select* from employees;
select* from departments;



SELECT employees.id, employees.name, departments.department_name
FROM employees
INNER JOIN departments
ON employees.department_id = departments.department_id;

SELECT employees.id,employees.name,departments.department_id, departments.department_name
FROM employees
LEFT JOIN departments
ON employees.department_id = departments.department_id;

SELECT employees.id,employees.name,departments.department_id, departments.department_name
FROM employees
right JOIN departments
ON employees.department_id = departments.department_id;

SELECT e.id,e.name,d.department_id, d.department_name
FROM employees e
right JOIN departments d
ON e.department_id = d.department_id;


SELECT employees.name, departments.department_name
FROM employees
LEFT JOIN departments
ON employees.department_id = departments.department_id
UNION
SELECT employees.name, departments.department_name
FROM employees
RIGHT JOIN departments
ON employees.department_id = departments.department_id;