SQL 计算的值是另外一个SQL查询结果,该如何写
求助 SQL 计算的值是另外一个SQL查询结果,该怎么写
我的是SQL2000的库 目前的SQL语句是这样的
用k.K3_xiaoliang/200000*100
请问大家如何把两个语句合并呢 如 “用第二个语句查询结果”/200000*100
------解决思路----------------------
你看看
我的是SQL2000的库 目前的SQL语句是这样的
语句一
SELECT top 1 r.dyxsmb,K.K3_xiaoliang as dysjxl,k.K3_xiaoliang/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
查询结果
dyxsmb dysjxl dydcb
200000 109807.8 54.9039
语句二
SELECT SUM(k3_xiaoliang) k3_xiaoliang FROM Kehu_jxs_Info WHERE kh_no IN (
SELECT kehuid FROM Ribao_UserToKehu WHERE userID='15')
用k.K3_xiaoliang/200000*100
请问大家如何把两个语句合并呢 如 “用第二个语句查询结果”/200000*100
------解决思路----------------------
你看看
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