how to select the type of join?

Question

Confused in which type of join should be used?

Answer 1

it depends on the situation. If you want all the COMMON results between two tables, then use inner join. If all the rows from left table is required use left join or if all the rows from right is required use right join.