SELECT
(SELECT count(*) as COUNT from WK_SHEET_TODO d WHERE SHID =1 AND T1.PROCID=d.PROCID) AS COUNT,
(select GROUP_CONCAT(USRID) AS MINIUSRID from WK_SHEET_MONITOR WHERE SHID = 1) as MINIUSRID,
(select GROUP_CONCAT(FULLNAME) AS MINIFULLNAME from WK_SHEET_MONITOR WHERE SHID = 1) as MINIFULLNAME,*
FROM
(SELECT FULLNAME,PDT,BLCMT,PUID,PROCID,CTRCD,SHID from WK_SHEET_WAIT a WHERE a.SHID = 1 and (exists(select * from WK_SHEET_PROC b where b.SHID=a.SHID) or exists(select * from WK_SHEET_WAIT c where c.SHID=a.SHID))
UNION
select FULLNAME,PDT,BLCMT,PUID,PROCID,CTRCD,SHID from WK_SHEET_PROC where SHID = 1 order by PDT DESC)T1
多张表无关联查询所需字段信息
最新推荐文章于 2023-02-22 11:45:56 发布