Let a database has two tables, Customers and Orders. The following figure shows the partial data of these two tables. Based on this partial data…

Let a database has two tables, Customers and Orders. The following figure shows the partial data of these two tables. Based on this partial data, explain Inner, Left, Right and Full join. Show the result set of each join operation.

Table: Customers

ID	First name
1	Rahim
2	Karim
3	Belal
4	Rony
5	Helal

Table: Orders

Order id	Amount	Customer id
1	200	10
2	500	3
3	300	6
4	800	5
5	150	8