清除用友任务明细

最新推荐文章于 2022-12-12 15:34:52 发布

xiadujian

最新推荐文章于 2022-12-12 15:34:52 发布

阅读量696

点赞数

CC 4.0 BY-SA版权

文章标签：任务 join user 工作 c

本文链接：https://blog.youkuaiyun.com/xiadujian/article/details/2134458

use ufsystem
select a.cacc_id as '账套号',iyear as '年度',a.cuser_id as '操作员编码' ,c.cuser_name '操作员',a.cstation '工作站点',
a.csub_id as '模块代码',csub_name as '模块名称',dintime as '登陆日期',d.cauth_name '企业模块',a.ctaskid '任务ID'
from ua_task as a
inner join ua_tasklog as b on a.ctaskid=b.ctaskid
inner join ua_user as c on a.cuser_id=c.cuser_id
inner join ua_auth as d on d.cauth_id=a.cauth_id
where a.cacc_id='804'