SQL Query

Write an update query to join the mail table with a table called mail2 where the email addresses match.Set Email field equal to 'X'.

create table mail(email varchar(50))
insert into mail values('sonia.sardana@yahoo.co.in')
insert into mail values('a.xzy@gmmail.com')


create table mail2(email varchar(50))
insert into mail2 values('a.xzy@gmmail.com')
insert into mail2 values('sardana.sonia@gmail.com')
select * from mail2

Final Query--
Update mail.email set email='X' where mail.email=mail2.email
Error is coming Invalid object name 'mail.email'. I want to update the entries in Mail Table.

Your syntax for UPDATE statement is incorrect.