Morgan Stanley interview question
Left join vs Right join
Interview Answer
Anonymous
3 Nov 2017
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.