Morgan Stanley interview question

Inner Join vs Outer Join? Right Join vs Left Join?