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_lo
Monday, May 31, 2004 2:37 PM
> To: MySQL Mailing List
> Subject: rework this
>
> I need help with this SQL.
> I want to delete all records from the 'audit_log_records' table that
> have 'tracker_id' columns that are the same as those from the audit
I need help with this SQL.
I want to delete all records from the 'audit_log_records' table that
have 'tracker_id' columns that are the same as those from the audit_log
table that have 'A' for the operation type.
delete from audit_log_records where tracker_id=(select tracker_id from
audit_log wh
