Why is right join required when we have left join | use of right join | why use right join instead of left join | is right outer join ever required | difference between left outer join and right outer join in sql | do we really need both left join and right join | Left vs right sql join