October 13, 2010 at 12:44 am
Please findout error in this query.When run that query, i am getting following message box
"specify the table containing the records you want to delete"
query
delete e
FROM EXISTING AS e INNER JOIN Aliganj_TriCAD_CI_Data_New AS M ON e.MTR_SRL_NO=M.MTR_SRL_NO
i am running this ms access
thanks in advance
October 13, 2010 at 6:20 am
I don't know how Access is calling this, but the TSQL command has correct syntax and should work. You might want to schema qualify the tables to ensure that you're getting the ones you expect. Other than that, I'm not sure. The problem must be on the Access side of things.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2010 at 6:23 pm
Unfortunately, this perfectly valid syntax is not valid in Access where you will have to revert to something nasty like this :w00t::
delete from EXISTING
where MTR_SRL_NO in
(
select MTR_SRL_NO from Aliganj_TriCAD_CI_Data_New
)
Oleg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply