多张表无关联查询所需字段信息

最新推荐文章于 2023-02-22 11:45:56 发布

原创最新推荐文章于 2023-02-22 11:45:56 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

Sql 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了一个复杂的SQL查询案例，该查询涉及多个表的联合查询、子查询、分组及聚合函数等高级用法，用于从待办事项、监控、等待处理和流程表中获取指定表单的数据，并展示如何统计特定流程的数量、合并相关人员ID及其姓名。

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