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
Post a Comment