Question: what are joins and mention different types of joins?
Answer: Inner Join. Inner join returns only those records/rows that match/exists in both the tables. ... 
Outer Join. We have three types of Outer Join. ... 
Cross Join. Cross join is a cartesian join means cartesian product of both the tables. ... 
Self Join.