Query involving data from different sources

[nodnud]

Hi,
I am trying to run a query to extract matching data from two different tables. For example, if two people wrote out a list of all the people they know, but one included the addresses of each person; I want to find the people they know in common and their address. There is no ID field in either table. I keep getting the error "The statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement."

I am running a make-table query as I want to perform analysis on the table afterwards in a different program.



Any help on this matter would be greatly appreciated!

[NTC]

Access 2003 has a Find Duplicates Query Wizard. Have you used this?