Mysql

[esteban garay]

update payments_detail set orders_id = (select o.orders_id from orders o,payments_detail d where d.invoice_id = o.invoices_id and o.categories_id = d.categories_id and o.orders_status <> 1) ;


pero no me funciona