关于嵌套查询中不能用（表名.列名）的问题。

[tao1203]

SELECT a.project_code,
(SELECT SUM(SUM_) FROM loan_notice b WHERE b.project_code = a.project_code ) loadmoney,
(select * from (select start_date from loan_notice b where b.project_code =a.project_code order by start_date) where rownum<2) start_date
FROM project a

ORA-00904: "A"."PROJECT_CODE": 无效的标识符

[sungangsg]

我也试过，好像嵌套不能超过两层

[tao1203]

就是啊 郁闷!不知道有啥办法能够解决!

[haru]

我感觉，在内层的嵌套里面，每次重新定义一次project a，应该好用

SELECT a.project_code,
(SELECT SUM(SUM_)
FROM loan_notice b, project c
WHERE b.project_code = c.project_code ) loadmoney,
(select * from
(select start_date
from loan_notice b,project d
where b.project_code =d.project_code order by start_date)
where rownum<2) start_date
FROM project a