SQL query ?铨

MsSQL?有??table..有data

TABLE 1

FID NAME
------------------------
1 TOM
2 DAVID
3 SAM
4 TONY
5 PETER


TABLE 2

ID FID NAME
------------------------
1 3 SAM
2 1 TOM
3 1 TOM
4 4 TONY
5 5 PETER

FID is foreign key

有什?方法可以retrieve D data result 是. (留意TOM's record)
ID FID NAME
==============
1 3 SAM
3 1 TOM <---- (取最大ID那?)
4 4 TONY
5 5 PETER

?????

(代?)