Hi,
I have a table which is the result of two merged tables containing 2003 and 2004 data. The merged table looks like this:
Merged:
ID Name Year
1 John 2003
2 John 2004
3 Mark 2003
4 Adam 2004
I am trying to retrieve ID, Name, Year for all records. Unless there are duplicates, ie John, then the record taken should be 2004 over 2003.
I am stuck on how to do this and it's probably a really simple query. Any help would be grateful.
Thanks a lot, regards
tubbsy123
I have a table which is the result of two merged tables containing 2003 and 2004 data. The merged table looks like this:
Merged:
ID Name Year
1 John 2003
2 John 2004
3 Mark 2003
4 Adam 2004
I am trying to retrieve ID, Name, Year for all records. Unless there are duplicates, ie John, then the record taken should be 2004 over 2003.
I am stuck on how to do this and it's probably a really simple query. Any help would be grateful.
Thanks a lot, regards
tubbsy123