SQL Joins

SQL JOIN

A JOIN clause is used to combine rows from two or more tables, based on a common column.

We will be using the CUSTOMER and ORDER tables as shown below:

Customer Table

ID	NAME	AGE	ADDRESS	SALARY
1	Mark	32	Texas	50,000
2	John	25	NY	65,000
3	Emily	23	Ohio	20,000
4	Bill	25	Chicago	75,000
5	Tom	27	Washington	35,000
6	Jane	22	Texas	45,000

Orders Table

ORDER_ID	DATE	CUSTOMER_ID	AMOUNT
100	2019-09-08	2	5000
101	2019-08-20	5	3000
102	2019-05-12	1	1000
103	2019-02-02	2	2000