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.