Domanda di colloquio di HSO Enterprise Solutions

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

Risposta di colloquio

Anonimo

23 giu 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.