sql query help

[blur]

I have two tables.
First one have 12.000 emails
Second one have 1.700 emails.

The first 12.000 emails contains the second 1.700 emails.

I want to delete these 1.700 mails from First table

How can i do that with a simple sql query ?

[DaveMaxwell]

Something like this should work for you.....

Delete from Table1 where emailID in (select emailId from table2)