select C.id,C.cname,SUM(A.amoney) from C,A where C.CCODE=A.CCODE GROUP BY C.ID,C.NAME
sql 两表关联查询加分组
最新推荐文章于 2024-03-20 20:57:44 发布
select C.id,C.cname,SUM(A.amoney) from C,A where C.CCODE=A.CCODE GROUP BY C.ID,C.NAME