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]
|
|
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
