Selecting from three tables?

[NewToAspDotNet]

Hi all, i have three tables: table 1 has two colomns: name and id table 2 has two columns: countrycode and id(id in this table is the forgin key from table one) table 3 has two columns: countryname and countrycode(countrycode is the forggin key from table two) now i have to make a query to select the name from table one and the countryname that belongs to that name from table three :~ . can anyone help me to make this query??? Thanx.

[leoinfo]

SELECT t1.name, t3.countryname
FROM [table 1] as t1
INNER JOIN [table 2] as t2 ON t2.id = t1.id
INNER JOIN [table 3] as t3 ON t3.countrycode = t2.countrycode