Hi Shutzy
If you remember Access 2003, I have used design Query ,linked/ Join by dragging the common feilds. And then selecting * from both the tables.
Yes both the Table are local. But the catch is The join is between 2 Queries not Tables.
But it is a basic Query where I have concatinated...