Pergunta de entrevista da empresa HSO Enterprise Solutions

Can you explain the difference between an Inner Join and left outer join in SQL

Resposta da entrevista

Sigiloso

23 de jun. de 2020

(INNER) JOIN: Returns records that have matching values in both tables. LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table.