Query to remove entries from table1 that exist in table 2

[newtosql]

Im new to sql server.

I have two tables, I need to write a query that will take the values out of one table if they exist in another table.
Each table has one column only and they are varchar(250). Each table has approx 20,000 rows.

I need to remove entries from table1 that already exist in table2.

Example as follows:

Table1 Table2
------ ------
car car
bus train
train blue
red bike
blue ....
green
bike
....

Thanks guys

 

[hmckillop]

A temporary index on both tables on the joining field would help the access prior to deletion, but you can do the actual query many ways but the simplest is probably:

DELETE T1
FROM Table1 t1
INNER JOIN table2 t2 on t1.matchfield = t2.matchfield

"I'm living so far beyond my income that we may almost be said to be living apart