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
(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