Pergunta de entrevista da empresa Morgan Stanley
Left join vs Right join
Resposta da entrevista
Sigiloso
3 de nov. de 2017
A left join returns all rows in the left table with matching rows in the right that satisfy the given ON condition. A right join returns all rows in the right table with matching rows in the left tables that satisfy the given ON condition.