Pregunta de entrevista de Smoothstack

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

Respuesta de la entrevista

Anónimo

5 de feb de 2021

In SQL, a join is used to compare and combine — literally join — and return specific rows of data from two or more tables in a database. An inner join finds and returns matching data from tables, while an outer join finds and returns matching data and some dissimilar data from tables.