This works:
SELECT geodesic_classifieds_userdata.id FROM geodesic_classifieds_userdata
LEFT JOIN subscriber ON
geodesic_classifieds_userdata.id=subscriber.GeoClassID
WHERE subscriber.GeoClassID IS NULL;
Please check this syntax for a DELETE statement
DELETE geodesic_user_data gud, subscriber s
FROM gud
WHERE gud.id != s.GeoClassID
or would this work:
DELETE geodesic_user_data gud, subscriber s
FROM gud
LEFT JOIN subscriber ON geodesic_classifieds_userdata.id=subscriber.GeoClassID
WHERE subscriber.GeoClassID IS NULL;
We're stuck with MySQL 4.0.17 so the subquery approach isn't possible.
Regards - Miles
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.412 / Virus Database: 268.18.3/696 - Release Date: 2/21/2007
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
