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
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货