oracle数据库 提示标识符无效

update
b_project_setup
set
PLAN_MANAGER_ID =null ,
PLAN_COLLECT_ID =null,
ENTITY_DESC='专项投资专业已作废'
where
(b_project_setup.PROJECT_DETAIL_ID = b_project_detail.ID) and (b_proj_info.ID = b_project_detail.PROJ_INFO_ID) and (b_proj_info.SPEC_ID = 1304)

DBCException: SQL 错误 [904] [42000]: ORA-00904: "B_PROJ_INFO"."SPEC_ID": 标识符无效
java.sql.SQLException: SQLException: ORA-00904: "B_PROJ_INFO"."SPEC_ID": 标识符无效

你修改的条件是有两张表的数据？

你更新的是表b_project_setup， 你后面的where 条件为什么有这个条件 b_proj_info.SPEC_ID

需要from b_proj_info这个表。要不他怎么知道要关联这个表那？