*delete** from members_temp where email like '(select distinct email from news)' *
Answer 2: remove the quotes. delete from members_temp where email like (select distinct email from news) Otherwise you're trying to delete a member who has the email address "(select distinct email from news)" which is a very odd email address. -- Del -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
