So i have a very large data set on a server that i need to shrink. I have a list of names in a table locally on my computer with ms access. I want to create an inner join from my small local table to this huge server table. I was thinking I would just do a pass through query in ms access and inner join the two tables, but when i do a pass through query MS access can't find my local table (it only recognizes the tables on the server). How can i join the two? Here is my current code:
select field1, field2
from tablea inner join tableb
on tablea.field1=tableb.field2
;
