Joining two tables

mlamont

Registered User.
Local time
Today, 14:38
Joined
Jun 25, 2001
Messages
45
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?
 
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?
 

Users who are viewing this thread

Back
Top Bottom