Difference between left join and right join in mysql

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 is used to retrieve all records from the left table and matching records from the right table.
Right join is used to retrieve all records from the right table and matching records from the left table.
If there is no match in the right table for a record in the left table, the result will still include that record with NULL values for the right table columns in left join.
If there is no match in the left table for a record in the right table, the result will still include that record with NULL values for the left table columns in right join.

Difference between left join and right join in mysql

Popular interview questions of Full Stack Developer

Top HR questions asked in VivaConnect Full Stack Developer