

-------------------
emp_a 模拟你的员工表,emp_b模拟你的兼职表,两张表之间通过id关联
with emp_a as(
select '1' [id],'张三' [NAME]
UNION ALL
select '2' [id],'李四' [NAME]
UNION ALL
select '3' [id],'王五' [NAME]
UNION ALL
select '4' [id],'孙六' [NAME]
UNION ALL
select '5' [id],'赵七' [NAME]
UNION ALL
select '6' [id],'王八' [NAME]
),
emp_b as(
select '2' [id]
union all
select '5' [id]
)
select *,(case when isnull(t.jz,'')='' then NAME else CONCAT(NAME,'(兼职)') end ) [name_] from (
select emp_a.*,emp_b.id [jz] from emp_a left join emp_b on emp_a.id=emp_b.id
)t
