Can you achieve the same result as LEFT JOIN by using RIGHT JOIN?
Rajanikant Hawaldar
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.
yes. Just switch the table positions and use LEFT JOIN instead of RIGHT JOIN and you get the same result. Even from performance standpoint there should be no difference. We do not really need a RIGHT JOIN.
Yes , we can reverse the table to achive the same
Ya we can We can exchange table nameAnd use right join.