...pp,printers ps, posdetail pd,posheader ph,userse u
where ph.transact=pd.transact and ph.userid=u.id and pd.prodnum=p.prodnum and p.prodnum*=pp.prodnum and pp.portid*=sp.portid and
sp.printerid=ps.id and ps.connectedtostation=1 and pd.transact=135 order by pd.uniqueid asc
the database...