> >testconnString = "Select webprddt7.qartmast.recseq, docno, partno, rtqty, srcdef, DATE(idate) As datei," +; >" webprddt7.qartmast.defects, webprddt7.qartdisps.disptype, webprddt7.qartdisps.rejsource," +; >" webprddt7.qartdisps.dispqty, webprddt7.qartdisps.location, webprddt7.qartdisps.recseq," +; >" webprddt7.qartdisps.dispcmnts, locindex, splitmo, sourceflag, vstockflag, purgepflag, disploc," +; >" localarw, dispwctr,webprddt7.qartdisps.buyerno, partname, corflag, caflag,webprddt7.qartdisps.vendorcode," +; >" webprddt7.qartdisps.vendorname, rmarflag From webprddt7.qartmast" +; >" Join webprddt7.qartsrcdef On webprddt7.qartsrcdef.recseq = webprddt7.qartmast.sourceflag" +; >" Left Join webprddt7.qartdisps On webprddt7.qartdisps.rtindex = webprddt7.qartmast.recseq" +; >" Left Join webprddt7.qartsubsrc On webprddt7.qartsubsrc.rtindex = webprddt7.qartmast.recseq" +; >" Where webprddt7.qartmast.recseq = 767899 And (deleteflag = 0 Or deleteflag is NULL)" > >Take a look at this blog post explaining your problem