22,209
社区成员
发帖
与我相关
我的任务
分享
select ap.zymc,yg.p_name,fg.name from Prj_OldProjectStaffArrange ap
left join SYS_Login yg on ap.ygbh=yg.Person_id
left join Prj_OldDivisionOfWork fg on ap.fgbh=fg.bh
where ap.ywbh ='N06-a-001';
SELECT
T1.zymc
,MAX(CASE T3.[name] WHEN '审核'THEN T2.p_name END)[审核]
,MAX(CASE T3.[name] WHEN '校对'THEN T2.p_name END)[校对]
,MAX(CASE T3.[name] WHEN '项目负责人'THEN T2.p_name END)[项目负责人]
FROM Prj_OldProjectStaffArrange T1
LEFT JOIN SYS_Login T2 ON T1.ygbh=T2.Person_id
LEFT JOIN Prj_OldDivisionOfWork T3 on T1.fgbh=T3.bh
WHERE T1.ywbh ='N06-a-001';
GROUP BY T1.zymc