Hi, I think is better to make a join between the tables: delete from news inner join news2 on news.* = news2.*
Hope it helps, Caterina -----Original Message----- From: Sofiane Sakhri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:00 PM To: [EMAIL PROTECTED] Subject: How can I delete from table element exist in other one Hello, How can I delete from teble "news" all that are existing in table "news2" the following don't work delete a.* from news where a in news2 Thanx ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Courrier : http://courrier.yahoo.fr --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
