单表多次join的sql 

select o1.emp_name as 员工姓名1 , o2.emp_name as 员工姓名2 from tableTest
join employee o1
on tabletest.[Emp_ID1] = o1.[emp_id] 
join employee o2
on tabletest.[Emp_ID2] = o2.[emp_id]

 

posted @ 2013-09-09 15:20  kelite  阅读(878)  评论(0)  编辑  收藏  举报