Factory: Перенос заказов на дату

9 – Статус – “На складе”

UPDATE fc_orderevent
SET  fc_orderevent.event_dt = '2012-11-30 23:59:59'
WHERE fc_orderevent.orderevent_id
IN (
select  orderevent_id from
(
SELECT fc_orderevent.orderevent_id
FROM fc_order
LEFT JOIN fc_orderevent ON ( fc_order.id = fc_orderevent.orderid )
WHERE fc_order.num
IN (
'2545', '2548', '2550', '2553', '2557', '2559', '2563', '2564'
)
AND fc_orderevent.stateid = '9' )
as tmpTable
);

Ссылки:
http://verysimple.com/2011/03/30/mysql-cant-specify-target-table-for-update-in-from-clause/