業務表 ? ?Business????業務ID ? ?BusinessID ? ?業務編碼 ? ?BusinessCode ? ?業務名稱 ? ?BusinessName ? ?集團名稱 ? ?GroupName ? ?業務類型 ? ?BusinessType ? ?承載類型ID ? ?BearerTypeID????記錄創建時間 ? ?CreatedOn ? ?記錄修改時間 ? ?ModifiedOn??員工表 ? ?Employee ? ?員工ID ? ?EmployeeID ? ?組ID ? ?EmployeeGroupID ? ?用戶名 ? ?EmployeeUsername ? ?密碼 ? ?EmployeePassowrd ? ?員工姓名 ? ?EmployeeName ? ?員工電話 ? ?EmployeeTel ? ?員工狀態 ? ?EmployeeStatus ? ?員工職位 ? ?EmployeePosition ? ?所在部門 ? ?EmployeeDepartment ? ?記錄創建時間 ? ?CreatedOn ? ?記錄修改時間 ? ?ModifiedOn??網服表? ServiceManage網服ID ServiceManagerID業務ID??BusinessID?員工ID ? ?EmployeeID ? ?關系??????? Relation? （1，2，3）?要的結果業務名稱??? 集團名稱???? ?Relation?=1員工姓名????? Relation?=2 員工姓名?? Relation?=3? 員工姓名SELECT bu.BusinessName, (SELECT em.EmployeeName FROM ServiceManager sm LEFT JOIN Employee em ON sm.EmployeeID = em.EmployeeID WHERE sm.BusinessID = bu.BusinessID and sm.Relation = 1) AS ServiceManageNameA, (SELECT em.EmployeeName FROM ServiceManager sm LEFT JOIN Employee em ON sm.EmployeeID = em.EmployeeID WHERE sm.BusinessID = bu.BusinessID and sm.Relation = 2) AS ServiceManageNameB, (SELECT em.EmployeeName FROM ServiceManager sm LEFT JOIN Employee em ON sm.EmployeeID = em.EmployeeID WHERE sm.BusinessID = bu.BusinessID and sm.Relation = 3) AS ServiceManageNameC FROM Business bu剛自己想了個，不過有問題求改?
2 回答
Oo浮云oO
TA貢獻7條經驗 獲得超0個贊
<table> ?<tr> ??<th>功通</th> ??<th>業務名稱</th> ??<th>帶寬</th> ??<th>集團名稱</th> ??<th>承載類型</th> ??<th>區域類型</th> ??<th>聯系人</th> ??<th>聯系電話</th> ??<th>網服經理（A角）</th> ??<th>聯系電話</th> ??<th>網服經理（B角）</th> ??<th>聯系電話</th> ??<th>客戶經理</th> ??<th>聯系電話</th> ?</tr>
添加回答
舉報
0/150
提交
取消