On 05/31/04 15:42 Donny Simonton spoke:
It depends on which version of MySQL you are using. Since you are using a
subquery, I assume you are using a fairly new version.
Delete audit_log_records from audit_log_records, audit_log where
audit_log_records.tracker_id = audit_log.tracker_id and
audit_log.operation='A'
That should be it. It's called a multi-table delete, but you are only
deleting from one table. You can't use left join or inner join with a
multi-table delete or update. You have to do a comma join.
Donny
Great, thanks.
I have MySQL-4.0.18 and that worked.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
