跪求一SQL.....多谢大侠

Question

Table1
字段
项目ID     FProjectID
项目名称   FProjectName
项目金额   FProjectMoney
项目回收   FProjectComeIn
项目欠款   FProjectArre
...        ...
数据
项目ID  项目名称  项目金额  项目回收 项目欠款
000001  某某项目  10000     2000     8000Table2
项目ID     FProjectID
项目名称   FProjectName
完成产值   FFinshOutPut数据
项目ID  项目名称  完成产值  
000001  某某项目  100
000001  某某项目  200
000001  某某项目  300
000001  某某项目  400实现结果
项目    项目金额   完成产值                           比例
000001  10000      1000(注:Sum(Table2.完成产值))      项目回收/1000(注:Sum(Table2.完成产值)) 
          

Answer 1

select t3.FProjectID ,t3.FProjectMoney, t4.FFinshOutPut ,t3.FProjectComeIn/1000 
from table1 t3,
(select t1.FProjectID, sum(t2.FFinshOutPut) FFinshOutPut  from table1 t1,table2 t2
where t1.FProjectID =t2.FProjectID  group by t1.FProjectID) t4 
where t3.FProjectID=t4.FProjectID

Answer 2

SELECT
TABLE1.FPROJECTID
, TABLE1.FPROJECTMONEY
, SUM( TABLE2.FFINSHOUTPUT)
, TABLE1.FPROJECTCOMEIN/SUM( TABLE2.FFINSHOUTPUT)
FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.FPROJECTID = TABLE2.FPROJECTID
GROUP BY
TABLE1.FPROJECTID
, TABLE1.FPROJECTMONEY
, TABLE1.FPROJECTCOMEIN

Answer 3

select t1.FProjectID '项目', t1.FProjectMoney '项目金额', OutPutSum '完成产值', FProjectComeIn/OutPutSum '比例' 
       from table1 t1, 
           (select FProjectID, sum(FFinshOutPut) OutPutSum 
                       from table2 
                       group by FProjectID) t2 
       where t1.FProjectID=t2.FProjectID;