Link to home
Start Free TrialLog in
Avatar of robrodp
robrodpFlag for Mexico

asked on

deleting records from a table based on the fields of another table ms sql

I have a table1 with field1 and a table2 with field2

I want to delete all records in table1  that do not have a match in table 2 (if john is in table1 and not in table2 I want it deleted) I have done it in very complicated ways using left joins, temprary tables.. but there must be an easier way
ASKER CERTIFIED SOLUTION
Avatar of edlunad
edlunad
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial