This looks like what i want to do, but as soon as i try to run this (i'm running it in access with aci_zip as a local table and dbo_postalcodes as a linked table to the sql server), it asks me for the values of A.city, P.city, etc. so it clearly is not taking these values from the tables that...