Stefan Daniel
05/03/2021
Join is a clause that allow us to join tables and return a new one with the rows that verify a condition.
The difference is that in the left join a new relationship is created with all the columns that match and those on the left side. On the contrary, in a right join you have all the rows that match and those on the right side.
Left Join
Right Join
More info about it: Blog