Joining tables with similar fields

[thexxvi]

Good morning,

How would I go about joining tables with similar fields? I currently have three tables that show standings of teams (East, Central, and West). They all have the same fields:



East
Team Name
Wins
Losses
Ties
Points For
Points Against

Central
Team Name
Wins
Losses
Ties
Points For
Points Against

West
Team Name
Wins
Losses
Ties
Points For
Points Against


How would I combine them in a query so that all of the data from the tables are compiled into one table:

Overall Standings (East/Central/West)
Team Name
Wins
Losses
Ties
Points For
Points Against


Thank you in advance.

[ranman256]

they all should have been in the SAME tabl3e, with a [Region] field.
so just run an append query to the new table (and include a Region)