mysql [Err] 1093 错误

2019独角兽企业重金招聘Python工程师标准>>>

改成下面的样子，in 中在包一层，才可以 

update erp_cc_delivery set host_id=1,host_name='北京仓库'

where delivery_id in (

select delivery_id from (

select 

DISTINCT

ecd.delivery_id

from 

erp_cc_delivery ecd  

INNER JOIN erp_cc_delivery_detail ecdd on

ecd.delivery_id=ecdd.delivery_id

INNER JOIN erp_order eo 

on ecdd.order_id=eo.order_id

where ecd.host_type=2

and eo.host_id=1

)a

)

转载于:https://my.oschina.net/lavedream/blog/476744