Query Linked Back End Tables

[AKoval]

Hello.



I have 3 Tables on a Back End Database - each table has the exact same fields (ID, Cost, etc), only one table is for 2010, one for 2011, and one for 2012.

I'm looking to create a query that would query all of these tables for a given ID. The problem I'm running into is that when I run the query, I am getting back 3 fields rather than one. For example, I want the ID all to be in the same column, but running this query gives me 3: 2010.ID, 2011.ID, 2012.ID.

Is there a way I can build this query so it only gives me one column for ID?

Thanks in advance!
Tony

[pbaldy]

Well, the design isn't normalized, but a UNION query can pull them together for you.