[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    syntax error
From:       Bob Lockie <bjlockie () lockie ! ca>
Date:       2004-05-31 23:02:40
Message-ID: 40BBB990.2000805 () lockie ! ca
[Download RAW message or body]

I want to do something like this:

delete from records where records.id in (select audit_log_records.id 
from audit_log_records, audit_log where 
audit_log.tracker_id=audit_log_records.tracker_id and 
audit_log.operation='D');

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]