>I have one record for one year, but show 2 records for one ID
How many different years do you have in your table? My select will only work correctly in its present form if you have two records per each ID.
If it's not broken, fix it until it is.
My Blog