>>

>>Select MaxRecs as recseq, dr.failoc, dr.faistatus ;
>>From webprddt6.drawmfai dr ;
>>inner join (select Max(RecSeq) as MaxRecs, partno group by 2  ;
>>from webprddt6.drawmfai where partno = '860637-001' ) MaxRec ;
>>on Dr.PartNo = MaxRec.PartNo

>
>Actually, this would not work. Give me 5 minutes to make it correct.

Select MaxRecs as recseq, dr.failoc, dr.faistatus ;
From webprddt6.drawmfai dr ;
inner join (select Max(RecSeq) as MaxRecs, partno group by 2  ;
from webprddt6.drawmfai where partno = '860637-001' ) MaxRec ;
on Dr.PartNo = MaxRec.PartNo and dr.ReqSeq = MaxRec.MaxRecs

Assuming PartNo + RecSeq combination is unique.