Delete vs. Select with Table Variable

[dukeslater]

Can someone please tell me why this works:

select * from @missingvalues a where exists
(select 1 from @v_responses b
where a.questionID = b.questionID
and a.response = b.response)

but this does not:

delete from @missingvalues a where exists
(select 1 from @v_responses b
where a.questionID = b.questionID
and a.response = b.response)

Error message refers to invalid alias a but when I remove the references to it as follows the result set is empty:

delete from @missingvalues where exists
(select 1 from @v_responses b
where questionID = b.questionID
and response = b.response)

Thanks as always for your help...

 

[vongrunt]

Try delete a from @missingvalues a

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[dukeslater]

Bada bing! Always count on you, and always learn something. Thanks!