你看看 SELECT top 1 r.dyxsmb,K.K3_xiaoliang as dysjxl,(SELECT SUM(k3_xiaoliang) k3_xiaoliang FROM Kehu_jxs_Info WHERE kh_no IN ( SELECT kehuid FROM Ribao_UserToKehu WHERE userID='15'))/200000*100 AS dydcb FROM [ribaobiao2] AS r,[Kehu_jxs_Info] as k WHERE r.luruname_userID='15' AND k.kh_no in(747) order by r.id DESC
dydcb 对了 但是 K.K3_xiaoliang 这个销量不对了 应该显示出来合计的数
目前临时是这么做的 SELECT top 1 r.dyxsmb,(SELECT SUM(k3_xiaoliang) k3_xiaoliang FROM Kehu_jxs_Info WHERE kh_no IN ( SELECT kehuid FROM Ribao_UserToKehu WHERE userID='15'))AS K3_xiaoliang,(SELECT SUM(k3_xiaoliang) k3_xiaoliang FROM Kehu_jxs_Info WHERE kh_no IN ( SELECT kehuid FROM Ribao_UserToKehu WHERE userID='15'))/200000*100 as dydcb FROM [ribaobiao2] AS r,[Kehu_jxs_Info] as k WHERE r.luruname_userID='15' order by r.id DESC
SELECT top 1 r.dyxsmb,K.K3_xiaoliang as dysjxl,(SELECT SUM(k3_xiaoliang) k3_xiaoliang FROM Kehu_jxs_Info WHERE kh_no IN (
SELECT kehuid FROM Ribao_UserToKehu WHERE userID='15'))/200000*100 AS dydcb
FROM
[ribaobiao2] AS r,[Kehu_jxs_Info] as k
WHERE r.luruname_userID='15' AND k.kh_no in(747) order by r.id DESC
SELECT top 1 r.dyxsmb,(SELECT SUM(k3_xiaoliang) k3_xiaoliang FROM Kehu_jxs_Info WHERE kh_no IN (
SELECT kehuid FROM Ribao_UserToKehu WHERE userID='15'))AS K3_xiaoliang,(SELECT SUM(k3_xiaoliang) k3_xiaoliang FROM Kehu_jxs_Info WHERE kh_no IN (
SELECT kehuid FROM Ribao_UserToKehu WHERE userID='15'))/200000*100 as dydcb
FROM
[ribaobiao2] AS r,[Kehu_jxs_Info] as k
WHERE r.luruname_userID='15' order by r.id DESC
K.K3_xiaoliang 这个销量不对了,这是你语句一写的有误。如果要合计,又是按什么分组来统计。最好还是把数据贴出来。