Morgan Stanley Interview Question: Left join vs Right join... | Glassdoor

Interview Question

Technology Analyst Interview New York, NY

Left join vs Right join

Answer

Interview Answer

1 Answer

0

A left join returns all rows in the left table with matching rows in the right that satisfy the given ON condition. A right join returns all rows in the right table with matching rows in the left tables that satisfy the given ON condition.

Anonymous on Nov 2, 2017

Add Answers or Comments

To comment on this, Sign In or Sign Up.