Pergunta de entrevista da empresa Microsoft
- what's the difference between inner join and left outter join
Resposta da entrevista
Sigiloso
17 de out. de 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.