ADO.NET :: Retrieve Path From Multi Table To Load Image?

i suppose this is the place to write select statements? I have two tables

table 1
id productid product
1 555 games
2 556 other

table 2
id productid (fk) filepath Date
1 555 images/golf.jpg 10/12/2010
2 555 images/tennis.jpg 11/12/2010
3 555 images/football.jpg 13/12/2010
4 556 + +

i require all values from table1 plus filepath from table2 to get image from directory with the latest date. table 1 also has a control parameter on id

current select statement:

[Code]....