業(yè)務(wù)表 ? ?Business????業(yè)務(wù)ID ? ?BusinessID ? ?業(yè)務(wù)編碼 ? ?BusinessCode ? ?業(yè)務(wù)名稱 ? ?BusinessName ? ?集團(tuán)名稱 ? ?GroupName ? ?業(yè)務(wù)類型 ? ?BusinessType ? ?承載類型ID ? ?BearerTypeID????記錄創(chuàng)建時間 ? ?CreatedOn ? ?記錄修改時間 ? ?ModifiedOn??員工表 ? ?Employee ? ?員工ID ? ?EmployeeID ? ?組ID ? ?EmployeeGroupID ? ?用戶名 ? ?EmployeeUsername ? ?密碼 ? ?EmployeePassowrd ? ?員工姓名 ? ?EmployeeName ? ?員工電話 ? ?EmployeeTel ? ?員工狀態(tài) ? ?EmployeeStatus ? ?員工職位 ? ?EmployeePosition ? ?所在部門 ? ?EmployeeDepartment ? ?記錄創(chuàng)建時間 ? ?CreatedOn ? ?記錄修改時間 ? ?ModifiedOn??網(wǎng)服表? ServiceManage網(wǎng)服ID ServiceManagerID業(yè)務(wù)ID??BusinessID?員工ID ? ?EmployeeID ? ?關(guān)系??????? Relation? （1，2，3）?要的結(jié)果業(yè)務(wù)名稱??? 集團(tuán)名稱???? ?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貢獻(xiàn)7條經(jīng)驗 獲得超0個贊
<table> ?<tr> ??<th>功通</th> ??<th>業(yè)務(wù)名稱</th> ??<th>帶寬</th> ??<th>集團(tuán)名稱</th> ??<th>承載類型</th> ??<th>區(qū)域類型</th> ??<th>聯(lián)系人</th> ??<th>聯(lián)系電話</th> ??<th>網(wǎng)服經(jīng)理（A角）</th> ??<th>聯(lián)系電話</th> ??<th>網(wǎng)服經(jīng)理（B角）</th> ??<th>聯(lián)系電話</th> ??<th>客戶經(jīng)理</th> ??<th>聯(lián)系電話</th> ?</tr>
添加回答
舉報
0/150
提交
取消