27,579
社区成员
发帖
与我相关
我的任务
分享
select m.id as 单据ID,
k.user_name as 制单人姓名,
k.user_name as 审核人姓名,
k.user_name as 审批人姓名
from m_m as m
inner join sys_user as k
on m.make_man = k.user_id
and m.check_man = k.user_id
and m.ok_man = k.user_id
where k.ws_id = 2
select m.id as 单据ID,
make.user_name as 制单人姓名,
che.user_name as 审核人姓名,
ok.user_name as 审批人姓名
from m_m as m
left join sys_user as make on m.make_man = make.user_id
left join sys_user as che on m.check_man = che.user_id
left join sys_user as ok on m.ok_man = ok.user_id
where make.ws_id = 2
select a.id,b.user_name 制单人,c.user_name 审核人,d.user_name 审批人
from m_m a
inner join sys_user b on a.make_man=b.user_id
left join sys_user c on a.check_man = c.user_id
left join sys_user d on a.ok_man = d.user_id and b.ws_id=2
select a.id,制单人姓名=b.user_name,审核人姓名=c.user_name,审批人姓名=d.user_name from m_m a
left join sys_user b on a.make_man=b.user_id
left join sys_user c on a.check_man=c.user_id
left join sys_user d on a.ok_man=d.user_id
select a.id,制单人姓名=b.user_name,审核人姓名=c.user_name,审批人姓名=d.user_name from m_m a
left join sys_user b on a.make_man=b.user_id
left join sys_user c on a.check_man=c.user_id
left join sys_user d on a.ok_man=d.user_id
select a.id,b.user_name 制单人,c.user_name 审核人,d.user_name 审批人
from m_m a
inner join sys_user b
on a.make_man=b.user_id
left join sys_user c
on a.check_man = c.user_id
left join sys_user d
on a.ok_man = d.user_id
where b.ws_id=2 --2号车间
select '单据ID'=A.id,'制单人姓名'=B.user_name,'审核人姓名'=C.user_name,'审批人姓名'=D.user_name
from m_m A
left join sys_user B on A.make_man=B.user_id
left join sys_user C on A.make_man=C.user_id
left join sys_user D on A.make_man=D.user_id
where exists(select 1 from sys_user where A.make_man=user_id and ws_id='002')