>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
Insanity: Doing the same thing over and over and expecting different results.
