> >sql = "Select recseq, partno, dwgrev, dwgtitle," +; >" faistatus, engno, failocn, datstmpi From webprddt7.drawmfai" +; >" Left Join amflib7.itemasa On amflib7.itemasa.itnbr = webprddt7.drawmfai.partno" +; >" Where " + luField + luString + " Order By partno, datstmpi DESC" > >