晕了count是算出“一个单位”农垦企业人员的数量 ,我查询出来的有很多单位哒嘛! 就要把他们的全部加起来啊,求的就是这个 UNOI SELECT SUM(农垦企业人员) FROM 表名我不知道写什么 问题就在这里!!!!
SELECT A.RESNAME 地区, (SELECT count(*) FROM T_BYW_DBSP WHERE APPLY_DATE <'' and FAMILY_ID in(select FAMILY_ID from T_BASIC_MEMBERINFO where EDU_LEVEL='04' and IS_COUNTRY='0' and STREET_GUID=A.ORGUNIT_ID) ) AS 农垦企业人员 from T_YBS_UNIT A where A.PARENTUNIT_ID='' union allSELECT '', (SELECT count(*) FROM T_BYW_DBSP WHERE APPLY_DATE <'' and FAMILY_ID in(select FAMILY_ID from T_BASIC_MEMBERINFO where EDU_LEVEL='04' and IS_COUNTRY='0') ) AS 农垦企业人员 from T_YBS_UNIT A where A.PARENTUNIT_ID='' 大概是这样,你的语句有问题,帖个结构可以给你改改
UNOI
SELECT SUM(农垦企业人员) FROM 表名我不知道写什么 问题就在这里!!!!
(SELECT count(*) FROM T_BYW_DBSP WHERE APPLY_DATE <'' and FAMILY_ID
in(select FAMILY_ID from T_BASIC_MEMBERINFO
where EDU_LEVEL='04' and IS_COUNTRY='0'
and STREET_GUID=A.ORGUNIT_ID)
) AS 农垦企业人员
from T_YBS_UNIT A where A.PARENTUNIT_ID='' union allSELECT '',
(SELECT count(*) FROM T_BYW_DBSP WHERE APPLY_DATE <'' and FAMILY_ID
in(select FAMILY_ID from T_BASIC_MEMBERINFO
where EDU_LEVEL='04' and IS_COUNTRY='0')
) AS 农垦企业人员
from T_YBS_UNIT A where A.PARENTUNIT_ID='' 大概是这样,你的语句有问题,帖个结构可以给你改改