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 aORA-00904: "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 aORA-00904: "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