> >String where = " Where pinbr Like " + lookupString + " And posstr(pinbr, 'DEV') < 1 And posstr(pinbr, 'DYN') < 1 And posstr(pinbr, 'ST') < 1 And posstr(pinbr, 'CDR') < 1"; > >"Select pinbr, cinbr, ITDSC, qtypr From amflib1.pstdtl" +; >" Join " amflib1.itment" +; >" On amflib1.pstdtl.cinbr = amflib1.itment.itnbr" +; >where > >