34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT U.[StoreNum]-I.[DetailNum]
FROM
(SELECT SUM(StoreNum) AS StoreNum FROM TEST1) AS U,
(SELECT SUM(DetailNum) AS DetailNum FROM TEST2) AS I
SELECT isnull(U.[StoreNum],0) - isnull(I.[DetailNum] ,0)
FROM
(SELECT SUM(StoreNum) AS StoreNum FROM TEST1) AS U,
(SELECT SUM(DetailNum) AS DetailNum FROM TEST2) AS I