select a.HtNo,a.CpName,a.CpGg,a.ClName,a.ClGg,SUM(a.CgNumber) cgz ,SUM(a.TotalPrice) zongm from CgTable a ,JsbTable b where a.HtNo=b.HtNo group by a.HtNo,a.CpName,a.CpGg,a.ClName,a.ClGg CgNumber和TotalPrice这两个字段都是decimal(18, 4)型 望大神指点一下 万分感谢