Pregunta de entrevista de Soros Fund Management

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

Respuesta de la entrevista

Anónimo

1 de ene de 2019

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