The following actually returns two records. One for vendor code G7820 and one for SEE SCAN. I need the one with the last datstmpi value.

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"