Pergunta de entrevista da empresa Scotiabank
What is the difference between the types of join?
Resposta da entrevista
Sigiloso
10 de jan. de 2026
Inner join - returns only the rows that have matching values in both tables. Left join - returns all rows from the left table, and matching rows from the right table. Right join - returns all rows from the right table, and matching rows from the left table. Full outer join - returns all rows from both tables, matching where possible.