lsqlstring = " SELECT Purchase.*, Accmst.accname, Depts.deptname;
               FROM  purchase LEFT OUTER JOIN accmst;
               LEFT OUTER JOIN depts ;
               ON  Purchase.department = Depts.deptno  ;
               LEFT OUTER JOIN Accmst ;
               ON  Purchase.partycode = Accmst.acccd"