How to make the select statement in MS sql?

[nebrom]

I am developing windows application using C# and MS sql.
I have the following tables.

table1
pkid Name
101 Meles
102 Zenawi
103 Mekele
104 Kenenisa

table2
pkid2 datepaid PKid
10 13/3/2012 101
11 16/4/2012 101
12 25/9/2012 101

13 14/9/2012 102
14 27/9/2012 102
15 15/10/2012 102

now i want to select name from the first table table1 and the latest datepaid from the second table table2. both table is connected by foreign key(from table1 into table2.. PKid)
i expect the resutlt to be
Name datepaid
Meles 25/9/2012
Zenawi 15/10/2012
how do i make the select statement please help me?
thanks

[jmcilhinney]

This question has nothing specific to do with C#. SQL code is the same whether you're executing it in a management tool or in an application regardless of the language that application was built in. Please post your SQL questions in the Database Development forum in future.

SELECT t1.Name, MAX(t2.datepaid)
FROM table1 t1 INNER JOIN table2 t2
ON t1.pkid = t2.PKid
GROUP BY t1.Name