Pregunta de entrevista de Microsoft

- what's the difference between inner join and left outter join

Respuesta de la entrevista

Anónimo

17 oct 2011

inner join matches the records where they are sharing a column value given in the query. On the other hand left outer join includes all records in the 'left' table even if there is no matching column value in the 'right' table.