testString = "Select recseq, CASE WHEN faistatus = 1 THEN 'Accepted' WHEN faistatus = 2" +; " THEN 'Rejected' ELSE 'SEE ORIGINAL FAI' END As fais, inspectord, dwgrev, datstmpi From webprddt6.drawmfai" +; " mt1 JOIN ( SELECT webprddt6.drawmfai.partno, MAX(webprddt6.drawmfai.datstmpi) AS MaxDate FROM" +; " webprddt6.drawmfai Where toolinspr = 0 And conformir = 0 And DATE(datstmpin) is Not NULL" +; " GROUP BY webprddt6.drawmfai.partno, webprddt6.drawmfai.vendorcode ) mt3 ON mt3.partno = mt1.partno" +; " AND mt3.MaxDate = mt1.datstmpi Where mt1.partno in('840950-15-999 F','840950-15 F','840950-15-999 '" +; ",'840950-15-9','840950-15-','840950-15','840950-1') And (Left(mt1.vendorcode,5) = 'G7820' Or" +; " (mt1.dwgtitle = 'See original FAI' And Left(mt1.vendorcode,8) = 'SEE SCAN')) And toolinspr = 0 And conformir = 0"