>TEXT TO testString NOSHOW TEXTMERGE PRETEXT 15 > with SelCTE as ( Select recseq, CASE WHEN faistatus = 1 > THEN 'Accepted' > WHEN faistatus = 2 > THEN 'Rejected' > ELSE 'SEE ORIGINAL FAI' END As fais, > inspectord, dwgrev > FROM webprddt6.drawmfai mt1 > INNER JOIN (SELECT webprddt6.drawmfai.partno, MAX(webprddt6.drawmfai.inspectord) AS MaxDate > FROM webprddt6.drawmfai > GROUP BY webprddt6.drawmfai.partno, > webprddt6.drawmfai.vendorcode ) mt3 > ON mt3.partno = mt1.partno AND mt3.MaxDate = mt1.inspectord > WHERE (mt1.partno = '116405-015' Or mt1.partno = '116405-015') And Left(mt1.vendorcode,5) = 'G7135') select MaxDate, inspectord, dwgrev, cast(sum(case when Fais = 'Accepted' then 100000 else 1 end) as int) as Check from SelCTE group by MaxDate, inspectord, dwgrev having mod(sum(case when Fais = 'Accepted' then 100000 else 1 end))/100000 between 1 and 2 inner join (select * from SelCTE where Fais = 'Accepted')) Multiple on SelCTE.MaxDate = Multiple.MaxDate and ... UNION ...That's the idea, basically.