Can you achieve the same result as LEFT JOIN by using RIGHT JOIN?
Yes and No.
Why Yes?
If records are well-managed and no null records found in both left and right table, we can replace left join with right one.
If we swap left and right tables, then we can replace left join with right join.
Why No?
Obviously we can’t replace, else why we have 2 joins.
In case of tables with null or not normalized records, we can replace left join with right join, it would end up with different result set.
Ya we can We can exchange table nameAnd use right join.