Hi I am hoping some of you nice poeple can spend a few mins to help me out.

example:

table 1: id, name

table 2: id,table_1_id, date

Table 2 holds multiple rows that link to table 1 on the fk table_1_id.

My result set wants to be include just one row from table 2 which holds the latest date - (or even the max(id) )

so if we have :

table1:

1, Jim

table 2:
1, 1, 01-01-2010
2,1, 01-01-2009
3,1, 01-01-2008

I just want to be able to get a 1:1 on the join , and get just the table2 row 1 back....


hope that makes sense?