Amazon Interview Question
Technical Support EngineersTeam: AWS
Country: United States
Interview Type: In-Person
INNER JOIN: Returns all rows when there is at least one match in BOTH tables
LEFT JOIN: Return all rows from the left table, and the matched rows from the right table
RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table
FULL JOIN: Return all rows when there is a match in ONE of the tables
From W3Schools website.
Inner join returns common records between both the tables whereas left join returns all rows from left table & the matching rows from right table.
- Anonymous May 18, 2014