Pregunta de entrevista de Morgan Stanley

Left join vs Right join

Respuesta de la entrevista

Anónimo

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.