Pergunta de entrevista da empresa Soros Fund Management

In SQL, what is the difference between an inner join and an outer join?

Resposta da entrevista

Sigiloso

1 de jan. de 2019

Inner Join - only shows common data from two or more tables, and removes duplicate. Outer Join - = returns unmatched rows from both tables