limiting results to the most recent date

[Mr.K]

I have two tables: tblA with PersonID field; tblB with PersonID field and AppointmentDates field. Tables are joined on PersonID field.
How to run a query which would return all records from tblA and only the most recent date from AppointmentsDates field from tableB?

Do I use GroupBy somewhere or Top 1 to acomplish this? Or maybe I should use a sub-query?

 

[Michael J Ross]

Group By Person ID and use Max for Appointmentdate

 

[Mr.K]

Michael J Ross - thanks man, that does it.