Hello, I hope I can achieve this query but can't figure it out. I use Access and will display in ASP Pages. I have a teams table with fields such as: TeamID City Nickname HistoricalID When a team moves I refer to the orginal team ID in the historical ID. i.e NYY New York Yankees NYY MON Montreal
Expos MON (Orig team) WAS Washington National ...