Not sure if I understand well what you want but how about this :
select * from webprddt6.drawmfai where recseq in (select max(recreq) from webprddt6.drawmfai where part no = '860637-001')
or
select top 1 * from webprddt6.drawmfai where part no = '860637-001' order by failoc desc, faistatus desc
>I need three fields from a remote data source.
>
>This is a data table of First Article Inspection records for our product part numbers.
>
>One part number can have multiple FAI's.
>
>RECSEQ = Sequiential Record Number
>FAILOC = FAI location
>FAISTATUS (Could be a 1 or 2)
>
>This SQL does not work because I don't have failoc or faistatus in the Group By section:
>
>Select Max(recseq) As recseq, failoc, faistatus From webprddt6.drawmfai Where part no = '860637-001' Group By partno
>
>This SQL does not work because it gives me the MAX recseq for the faistatus 1 and another for faistatus 2:
>
>Select Max(recseq) As recseq, failoc, faistatus From webprddt6.drawmfai Where part no = '860637-001' Group By partno, failoc, faistatus
>
>Please help.