S.no LEFT JOIN RIGHT JOIN
1. It gets the records from the rows of the LEFT side linked table and only the matching records from the RIGHT table. It gets the records from the rows of the RIGHT side linked table and only the matching records from the LEFT table.

Example

                                        

1. Left Join

SELECT column_list FROM table_1 LEFT JOIN table_2 ON column_name1 = column_name2 WHERE join_condition

2. Right Join

SELECT column_list FROM table_1 RIGHT JOIN table_2 ON column_name1 = column_name2 WHERE join_condition

Suggest An Answer