请大家帮忙看看这个sql语句怎么写! select a.CODE,sum(B.price) as sumprice from tableA A inner join tableB B on A.code=left(B.prjcode ,3) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select code=left(prjcode,3),sumprice=sum(price) from tableBgroup by left(prjcode,3) select a.CODE,sum(B.price) as sumprice from tableA A inner join tableB B on A.code=left(B.prjcode ,3) group by A.code create Table tableb (prjcode varchar(20), price money)Insert tableb (prjcode, price) values ('1.1.1', 555)Insert tableb (prjcode, price) values ('1.1.2', 323.33)Insert tableb (prjcode, price) values ('1.1.22', 33)Insert tableb (prjcode, price) values ('1.2.86', 323)Insert tableb (prjcode, price) values ('1.2.23', 323)Insert tableb (prjcode, price) values ('1.3.4', 3232)Insert tableb (prjcode, price) values ('1.3.22', 111)Insert tableb (prjcode, price) values ('1.4.44', 21212)select left (prjcode, 3) as prjcode, sum(price) as price from tableb group by left (prjcode, 3)drop table tableb select code=left(prjcode,3),sumprice=sum(price) from tableBgroup by left(prjcode,3) 求数据同步解决办法 SQL创建用户的一个白痴问题。T_T 子表查询 多表联合查询 SQL Server中如何格式化一個字符串??急! 关于在表中插入一列的问题 新手急问:有一个sql异常,"...IDENTITY_INSERT 为 ON ..."?????? 关于“字符串判断”求助 有哪位知道SQL SERVER 2000中确定一个字符串在另一个字符串中的位置函数吗?(在线) SQL SERVER与DELPHI的DBEXPRESS连接有内存漏洞问题吗? 送分,顺便问个小问题。 如何把一个表的某个字段复制到另一个表的某个字段,复制条件是两表的某个字段相同.
group by left(prjcode,3)
from tableA A inner join tableB B on A.code=left(B.prjcode ,3) group by A.code
Insert tableb (prjcode, price) values ('1.1.1', 555)
Insert tableb (prjcode, price) values ('1.1.2', 323.33)
Insert tableb (prjcode, price) values ('1.1.22', 33)
Insert tableb (prjcode, price) values ('1.2.86', 323)
Insert tableb (prjcode, price) values ('1.2.23', 323)
Insert tableb (prjcode, price) values ('1.3.4', 3232)
Insert tableb (prjcode, price) values ('1.3.22', 111)
Insert tableb (prjcode, price) values ('1.4.44', 21212)select left (prjcode, 3) as prjcode, sum(price) as price from tableb
group by left (prjcode, 3)drop table tableb
group by left(prjcode,3)