select c.Name as 出题人姓名,
b.Question as 题目,
a.Answer as 答案,
d.Name as 回答人姓名
from Ans a
inner join Que b
on a.QID = b.QID
inner join Emp c
on c.EmpID = b.EmpID
inner join Emp d
on d.EmpID = a.EmpID
b.Question as 题目,
a.Answer as 答案,
d.Name as 回答人姓名
from Ans a
inner join Que b
on a.QID = b.QID
inner join Emp c
on c.EmpID = b.EmpID
inner join Emp d
on d.EmpID = a.EmpID
from emp as ae,emp as be,que,ans
where que.empid=ae.empid and ans.empid=be.empid and ans.qid=que.qid