montse 22199 (3/20/2013)

---

Hello all,
I need to delete a record that is duplicate between 2 tables.

The query looks like this:

Delete from request_form_table_testing as t1
where EXISTS
(select tEmail from request_form_temp_emails as t2
where t1.email = t2.tEmail)

but is giving me an error:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'as'.

I dont really know where is my syntax error.

Could you guys help me?

Thanks a lot

Delete request_form_table_testing 
where tEmail in
(
	select tEmail 
	from request_form_temp_emails as t2
	join request_form_table_testing t1 on t1.email = t2.tEmail
) 

delete request_form_table_testing 
from request_form_table_testing as t1
where EXISTS
(select tEmail from request_form_temp_emails as t2
where t1.email = t2.tEmail)