Option to reorganize FROM clause so that inner join and left join stay the same, and right join changes to left join
the original sql statment:
SELECT *
FROM T1 RIGHT JOIN T2 ON T1.ID1=T2.ID1
after reorganize
SELECT *
FROM T2 LEFT JOIN T1 ON T2.ID1=T1.ID1
3
votes
Denis
shared this idea