What are the differences between Left and Right Join

Question

Accepted Answer

Left join returns all records from left table and matching records from right table. Right join returns all records from right table and matching records from left table.

Left join keeps all records from the left table and only matching records from the right table
Right join keeps all records from the right table and only matching records from the left table
Left join is denoted by LEFT JOIN keyword in SQL
Right join is denoted by RIGHT JOIN keyword in SQL
Left join is useful when we want to see all records from the left table even if there are no matches in the right table
Right join is useful when we want to see all records from the right table even if there are no matches in the left table

What are the differences between Left and Right Join

Popular interview questions of Jr. Data Scientist