PostgreSQL-Learning/cross.sql at main · Hazrat-Ali9/PostgreSQL-Learning · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
CREATE TABLE employees (
    emp_id INT,
    emp_name VARCHAR(50),
    dept_id INT
);

CREATE TABLE departments (
    dept_id INT,
    dept_name VARCHAR(50)
);

-- Inserting sample data
INSERT INTO employees VALUES (1, 'John Doe', 101);
INSERT INTO employees VALUES (2, 'Jane Smith', 102);

INSERT INTO departments VALUES (101, 'Human Resources');
INSERT INTO departments VALUES (102, 'Marketing');


SELECT * from employees;
SELECT * from departments;

-- CROSS JOIN
SELECT * FROM employees
CROSS JOIN departments;

-- NATURAL JOIN
SELECT * FROM employees
NATURAL JOIN departments;