sql分类统计，条件中没有的为0
SELECT dic1.CRDCT_NAME AS jcdjPsName,(
select count(*) FROM CORE_DICT dic2 LEFT JOIN JCDJ_PARTYMEMBER ON(JCDJ_PMIDENTITY_UUID=dic2.CRDCT_CHAR_CODE)
WHERE JCDJ_PMOGNCODE like CONCAT('033001026','%' )
原创
2016-05-26 15:46:52 ·
2916 阅读 ·
0 评论
关注
分享
扫一扫