下面是mysql中的查询,我想判断branch_master中finance类型的branch id和year是否等于manager中的branch id和year,然后根据manager中的branch id更新manager表中的状态
UPDATE manager as m1
SET m1.status = 'Y'
WHERE m1.branch_id IN (
SELECT m2.branch_id FROM manager as m2
WHERE (m2.branch_id,m2.year) IN (
(
SELECT DISTINCT branch_id,year
FROM `branch_master`
WHERE type = 'finance'
)
)
)
但是犯了错误
表"m1"被指定两次,既作为"更新"的目标,也作为