I am trying to replace records in one database with records in another database, where the records in both databases share a key.
DELETE * FROM [MainTable] AS mtMaster INNER JOIN [C:\Table2.mdb].MainTable AS mtImport ON mtMaster.troubleCall = mtImport.troubleCall
I am getting "Specify the table containing the records you want to delete." I have a feeling the "AS" statements aren't doing their job.
I hope someone can help me out. I haven't used SQL in quite a while, so I'm having trouble, especially with this second database, and the fact that the tables have the same names in each database.
Thanks!
J
DELETE * FROM [MainTable] AS mtMaster INNER JOIN [C:\Table2.mdb].MainTable AS mtImport ON mtMaster.troubleCall = mtImport.troubleCall
I am getting "Specify the table containing the records you want to delete." I have a feeling the "AS" statements aren't doing their job.
I hope someone can help me out. I haven't used SQL in quite a while, so I'm having trouble, especially with this second database, and the fact that the tables have the same names in each database.
Thanks!
J