employer cover photo
employer logo
employer logo

HSO Enterprise Solutions

Engaged employer

HSO Enterprise Solutions interview question

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

Interview Answer

Anonymous

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