SQL和数据如下，如何让firstname跟在did,eid的后面

Question

SELECT emp.firstname,login.eid FROM login,emp WHERE emp.id=login.eid ORDER BY eid

firstname              eid  
------------------  --------
廖斌                         1
刘凯                         2
赵瑞涛                        3
张苗                         4
谷亚坤                        5
铁蛋                         6
铁柱                         7
余锴峰                        8
杜明                         9
周旭乾                       10
肖大帅                       11
梅许                        12
许佳瑞                       13
崔昊                        14
任朝辉                       15
胡彬                        19
邵岩松                       20
小潘                        21
陈祥辉                       22
刘煜                        23
蝎子莱莱                      24
徐梦亚                       25
韩宇纬                       26
王立宁                       28
席首华                       29
郝彦冰                       30
小潘的赵老哥                    31
柴国梁                       32
张凯旋                       33
隔壁老王                      34
宋磊                        35
暴志远                       37
吕顺                        38
娃娃                        39
苏慧                        40
孙克龙                       41
猪                         42
肖越的Son                    46

SELECT edrelationship.did,edrelationship.eid

FROM edrelationship ,dept

WHERE dept.id=edrelationship.did

    ORDER BY did ,eid

   did     eid  
------  --------
     1         3
     1         9
     1        20
     2        40
     3        10
     3        15
     3        16
     3        22
     3        25
     3        32
     3        41
     5         2
     5         5
     5        12
     5        14
     5        21
     5        24
     5        26
     5        27
     5        29
     5        30
     5        31
     5        33
     5        34
     5        37
     5        53
     6         8
     6        28
     7        39
     8         1
     8         4
     8         6
     8         7
     8        13
     8        19
     8        23
     8        35
     8        38
     8        42

Answer 1

SELECT B.DID, B.EID, A.firstname
FROM (SELECT emp.firstname firstname, login.eid eid
FROM login, emp
WHERE emp.id = login.eid) A,
(SELECT edrelationship.did did, edrelationship.eid eid
FROM edrelationship, dept
WHERE dept.id = edrelationship.did) B
WHERE A.EID = B.EID
ORDER BY B.DID, B.EID