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
![](https://secure.gravatar.com/avatar/4dc1f1827b8dff1d1d0e7de589f553f9?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)