Make a backup of your table (if its important) before trying any suggestions for deleting.
Here's my suggestion: DELETE FROM Ads WHERE uid IS NULL; Best regards, Jim at iDimensionz.com -- http://www.iDimensionz.com Professional web site design and affordable web site hosting. ------------------------------------------------------------------------ Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=38044&t=84> – Get the new open source web browser, FireFox, and enjoy features like pop up blocking, tabbed browsing and MUCH more! Get Thunderbird! <http://www.spreadfirefox.com/?q=affiliates&id=38044&t=178> – Get the new open source e-mail client, ThunderBird, and enjoy features like integrated spam filter, privacy protection, integrated RSS reader and MUCH more! dzoan-chau wrote: > > Hi, > > I am using mySQL version 3.23.54, and I need an equivalent delete > statement to the one below: > > delete Ads FROM Ads USING Ads LEFT JOIN Members ON Ads.uid=Members.uid > WHERE Members.uid IS NULL; > > I know that this delete statement works in 4.0 and above, but it just > doesn't work on mine (version 3.23.54). Any help would be greatly > appreciated. > > Johnny The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
