//之间不加空格的:concat(ES.NOTICE_ID,ES.DEPT_ID) select PUB.BILL_ID AS COUNT,ES.DEPT_NAME from ES_NOTICE_TARGET ES JOIN PUB_FILES PUB ON PUB.BILL_ID=concat(ES.NOTICE_ID,ES.DEPT_ID) GROUP BY PUB.BILL_ID ,ES.DEPT_NAME //加空格或者其他的: concat(concat(ES.NOTICE_ID,''),ES.DEPT_ID) select PUB.BILL_ID AS COUNT,ES.DEPT_NAME from ES_NOTICE_TARGET ES JOIN PUB_FILES PUB ON PUB.BILL_ID=concat(concat(ES.NOTICE_ID,''),ES.DEPT_ID) GROUP BY PUB.BILL_ID ,ES.DEPT_NAME
【数据库】------- sql concat函数实现单个表或多个表 进行多个字段值拼接代码
最新推荐文章于 2024-08-10 23:17:37 发布