( 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)
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) mt3" +; " ON mt3.partno = mt1.partno AND mt3.MaxDate = mt1.datstmpi" +; " Where mt1.partno in('" + p1 + "','" + p2 + "','" + p3 + "','" + p4 + "','" + p5 + "','" + p1 + "','" + p1 +; "') And toolinspr = 0 And conformir = 0"