query to copy a linked table

[Slip27]

problem is that in a query, if i have two copies of a linked table. Access labels the second copy _1. However, if i relabel the second table, and use the two together. i get an error message that say that the SQL cannot determine the difference. What can I do to fix this.

Thanks for your help.