SELECT
t1.Qlname,
t1.qlCenterZH,
t1.htprice,
isNULL((SELECT sum(CAST(t2.PrPayZYPrice AS decimal(18,3)) ) FROM np_ZXmZYpaylist t2 WHERE t1.QLxmJplanID = t2.xmJplanID) ,0) as zPrPayZYPrice,
isNULL((SELECT sum(CAST(t2.SumpayZYPrice AS decimal(18,3))) FROM np_ZXmZYpaylist t2 WHERE t1.QLxmJplanID = t2.xmJplanID) ,0) as zSumpayZYPrice ,
isNULL((SELECT sum(CAST(t2.SumUNpayZYPrice AS decimal(18,3))) FROM np_ZXmZYpaylist t2 WHERE t1.QLxmJplanID = t2.xmJplanID) ,0) as zSumUNpayZYPrice
FROM np_QLxmJplan AS t1
sql 子表联合查询
最新推荐文章于 2024-06-03 15:07:18 发布