SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: sql query help
-
Feb 28, 2002, 09:13 #1
sql query help
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 ?
-
Feb 28, 2002, 10:24 #2
- Join Date
- Nov 1999
- Location
- Mechanicsburg, PA
- Posts
- 7,294
- Mentioned
- 123 Post(s)
- Tagged
- 1 Thread(s)
Something like this should work for you.....
Delete from Table1 where emailID in (select emailId from table2)Dave Maxwell - Manage Your Site Team Leader
My favorite YouTube Video! | Star Wars, Dr Suess Style
Learn how to be ready for The Forums' Move to Discourse
Bookmarks