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
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