when you are merging two tables, how to decide which kinds of JOIN you should use?

Question

Im confused about RIGHT JOIN and LEFT JOIN

Answer 1

Depends on requirements. If you require all rows from left table and only the matching rows from right table,you will use left join. Similar approach for right join and full outer join.