joins are used to merge two tables or retrieve data from tables. It depends on the relationship between tables.
Following are the most commonly used joins in SQL:
Inner Join: inner joins are of three type:
- Theta join
- Natural join
- Equijoin
Outer Join: outer joins are of three type:
- right outer join
- Left outer join
- Full outer join