delete from members_temp where email like '(select distinct email from news)'
Perhaps the quote marks around your conditional are confusing things
I assume this is meant to be a nested query
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
Description: S/MIME cryptographic signature