Hi Guys,
I have a question regarding one to many relationship.

I have the following two tables
1) Table A
program_id
2)Table B
raceId
race_number
program_id

I have defined a one to many relationship between table A to Table B using key program_id.

My question is, I would like to specify a query to retrieve one to many relationship, caz for the same program_id the data in Table B get's changed periodically and only inserts are allowed in Table B.I would like to rerieve only the latest record from Table B associated with program_id in Table A.

Thanks in advance
ag