>lsqlstring = " SELECT Purchase.*, Accmst.accname, Depts.deptname; > FROM purchase LEFT OUTER JOIN accmst; > LEFT OUTER JOIN depts ; > ON Purchase.department = Depts.deptno ; > ON Purchase.partycode = Accmst.acccd"Don't nest the joins, e.g.
lsqlstring = " SELECT Purchase.*, Accmst.accname, Depts.deptname; FROM purchase ; LEFT OUTER JOIN accmst; ON Purchase.partycode = Accmst.acccd"; LEFT OUTER JOIN depts ; ON Purchase.department = Depts.deptno