SQL Server SQL syntax =* and right joins
Posted on 2016-07-25
I am struggling to understand the join conversion process, and how to nest right joins.
do the following have identical results?
from APOPEN O,APPayments P, APNewPayables N WHERE O.ApplytoId =* P.ApplytoId and N.voucherid =* P.applytoid
from (APOPEN RIGHT JOIN APPayments ON AOPEN.ApplytoId = APPayment.ApplytoId) RIGHT JOIN APNewPayables ON APNewPayables.voucherid = APPayment.applytoid