able2
FROM table1, table2
WHERE table1.bounce_email = table2.email
http://dev.mysql.com/doc/refman/5.1/en/delete.html
> -Original Message-
> From: Scott Haneda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 15, 2007 12:20 AM
> To: mysql@lists.mysql.com
> Subject: Poss
This is a one off I need to do
Table1 has email addresses in it, table two also has email addresses in it.
table1 represents bounced emails that need to be purged from the database.
What I would like to do, is mark a field in table2, called "needs_purging"
to true, when there is a match from tabl