SQL
查询发文
-- 查询发文
select * from T_OA_DISPATCH where NAME like '%奖%' and NUM like '%厦%房%' order by DISPATCH_ID desc
-- 查看传阅
select * from T_OA_DISPATCH_USER where DISPATCH_ID='38326'
-- 109163 DISPATCH_USER_ID
-- T_OA_DISPATCH_USER的USER_ID关联用户
-- 查用户
select * from T_EBM_USER where USER_ID='1111'
select * from T_EBM_USER where USER_NAME='xxx'
原创2021/12/31...大约 3 分钟