OLD sql server sql JOIN syntax
Posted on 2016-08-02
I am having issues converting the old syntax and wondered if any can convert the following to current SQL?
From APOPEN O, APPayments P, APNewPayables N Where O.ApplytoId =* P.ApplytoId and N.voucherid =* P.applytoid
These are apparently RIGHT OUTER JOINS (i.e. RIGHT JOINS)
I have tried both the following and neither seems to work correctly. I suspect #2 (RIGHT JOIN) is closer than a LEFT join, but maybe the table (JOIN) order needs to be changed?
1. from APOPEN O LEFT JOIN APPayments P ON O.ApplytoId = P.ApplytoId LEFT JOIN APNewPayables N ON N.voucherid = P.applytoid
2. from APOPEN O RIGHT JOIN APPayments P ON O.ApplytoId = P.ApplytoId RIGHT JOIN APNewPayables N ON N.voucherid = P.applytoid