Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no match in the subscriber table, but another set of eyes would be appreciated.
DELETE geodesic_user_data FROM geodesic_user_data LEFT JOIN subscriber ON geodesic_classifieds_userdata.id=subscriber.GeoClassID WHERE subscriber.GeoClassID IS NULL; Our hosting company uses MySQL 4.0.17 so the subquery approach is not possible. Thanks in advance - Miles -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.412 / Virus Database: 268.18.3/700 - Release Date: 2/24/2007 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
