项目回款.qpr

classical examples of database development based on Visual FoxPro 7.0

SELECT 回款.项目id, 项目.项目名称, SUM(回款.回款金额);
 FROM  projectmng!项目 INNER JOIN projectmng!回款 ;
   ON  项目.项目id = 回款.项目id;
 GROUP BY 回款.项目id;
 ORDER BY 回款.项目id