Searching a Column value of One Table by Another then Deleting Row


hello... i'm real new sql server express , need following.

 

i have 2 tables...

 

table 1: column emailaddress

 

table 2: column cust_id, emailaddress, firstname, lastname

 

i want search table 2 emailaddress, table 1 emailaddress, , if of email addresses in table 1 found in table 2, delete rows in table 2.

 

thanks,

car54

 

 

delete table2 emailaddress in (select emailaddress table1)

 

madhu



SQL Server  >  SQL Server Express



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........