I've identified records where I need to set a field to zero. Here's the query that identified the records:
select t1.iid from transactions t1 inner join payment_header h1 on h1.iid = t1.ipmthdrid where t1.iacctid <> h1.iacctid I tried to put an update in front of it like so but it fails: update transactions set ipmthdrid = 0 where iid in ( select t1.iid from transactions t1 inner join payment_header h1 on h1.iid = t1.ipmthdrid where t1.iacctid <> h1.iacctid) MySQL5 gives me this error: "You can't specify target table 'transactions' for update in FROM clause" Tips for solution? tia! --Michael _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
