alas subqueries arent supported in 4.0, yo uwill need to update to
4.1 or beyond
subquery syntax is documented here
http://dev.mysql.com/doc/refman/4.1/en/subqueries.html
but should look like.
delete from members_temp where email = (select distinct email
from news)
Dean
Terry Denovan wrote:
Hi Sluggers,
I am trying to write an SQL Statement and require some help.
I have sent out a mass email to all the email address’s in table “news”,
now that is an old table, and I am required to send out the exact same
email to everyone in the “members_temp” table, but I need to delete all
the people out of the “members_temp” where the email exists in the
previous “news” table.
I have tried the following statement, it seems to run, but doesn’t
delete any records. Im using mysql ver 4.0.25-standard
*delete** from members_temp where email like '(select distinct email
from news)' *
**Terry Denovan**
**Express Publications Pty Ltd**
50 Silverwater Rd
Silverwater, NSW, 2128
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
Tel:
Fax:
Mobile:
02-9741-3944
02-9741-3997
0414-459-775
The information contained in this e-mail communication may be
confidential. You should only read, disclose, re-transmit, copy,
distribute, act in reliance on or commercialise the information if you
are authorised to do so. If you are not the intended recipient of this
e-mail communication, please immediately notify the sender by e-mail and
then destroy any electronic or paper copy of this message.
Any views expressed in this e-mail communication are those of the
individual sender, except where the sender specifically states them to
be the views of Fexious Pty Ltd. Fexious Pty Ltd does not represent,
warrant or guarantee that the integrity of this communication has been
maintained nor that the communication is free of errors, virus or
interference.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
