Joining two tables

[mlamont]

I have two tables with the exact same configuration, I need to create a query that joins the two of them together. When I have attempted to do this so far I get an error saying that it could not complete the SQL statement because of ambiguous outer joins.

Can anybody help me?

 

[Travis]

Are you trying to take to tables that are alike and combine them together? (e.g. a table with 100 records and a table with 50 records -> become a Query that returns 150 records)

If so, are you using a "UNION" or "UNION ALL" Query?

Or

Are you trying to link two tables together? (e.g. One-to-One, or One-to-Many, Left, Inner...)

If so did you set up the relationship in the "Relationship" Window?