SQL JOINS - Most asked interview question

What are the types of JOINS?
1. Inner Join: retrieves the matched rows only.
2. Left Join retrieves all records from the left table and the matching records from the right table.
3. Right Join: retrieves all records from the right table and the matching records from the left table.
4. Full Join: retrieves all rows from both joined tables. It doesn't matter if there is a match or not.

[@saramushtaq6409]

Super helpful. Thank you

[@farazmushtaq1675]

Very useful tutorial. Thank you Sid