SELECT FULLNAME,PDT,BLCMT,CBCT from WK_SHEET_WAIT a WHERE a.SHID = %SHID% 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,CBCT from WK_SHEET_PROC where SHID = %SHID%
两张表合并查询获得联合数据
最新推荐文章于 2023-10-12 08:58:52 发布