MySQL Left Join and Right Join

MySQL Left Join:

MySQL Left Join clause allows you to select rows from both left and right tables that are matched, plus all rows from the left table even with no matching rows found in the right table.

MySQL Right Join:

MySQL Right Join is simply the counterpart to the left join and works the same as the Left Join, except that all values are retrieved from the table on the right.

MySQL Left Join Syntax:

MySQL Right Join Syntax:

MySQL Left Join and Right Join:

Sample Table:

MySQL Left Join on Sample Table:

MySQL Right Join on Sample Table: