Explain the difference between the left join & right to join?
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. |
Also Read: MySQL Tricky Interview Questions
Suggest An Answer
No suggestions Available!