我认为你的描述不太清楚哦。
A表和B表有什么关系?难道是他们的NO有联系?
希望你能描述清楚一点。
现在我根据你的描述猜测着写一下:
select count(b.point) where vo = '1' or vo = '2' and a.NO = b.NO
A表和B表有什么关系?难道是他们的NO有联系?
希望你能描述清楚一点。
现在我根据你的描述猜测着写一下:
select count(b.point) where vo = '1' or vo = '2' and a.NO = b.NO
select sum(B.POINT) from B left join A on A.NO=B.NO where A.NO=... and (B.VO='1' OR B.VO='2')
FROM (a LEFT JOIN
(select b.NO,sum(b.POINT) SUM1 from b where b.VO=1 group by b.NO) b1
ON a.[NO] = b1.[NO])
LEFT JOIN
(select b.NO,sum(b.POINT) SUM2 from b where b.VO=2 group by b.NO) b2
ON a.[NO] = b2.[NO]