34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT a.`name` as '创建人' from wl_userinfo a, wl_run_worktask b WHERE a.username = b.TASK_CLAIMER
UNION
SELECT c.`name` as '当前执行人' from wl_userinfo c, wl_run_worktask d WHERE c.username = d.task_assignee
SELECT a.name AS 创建者 ,
c.name AS 当前执行人
FROM wl_run_worktask b
JOIN wl_userinfo a ON b.TASK_CLAIMER = a.username
JOIN wl_userinfo c ON b.TASK_ASSIGNEE = c.username