SQL查询从表中检索数据
问题描述：
一个雇员表，其字段为:SlNo，Ename，MgrID.
SlNo EName MgrId
1 A 2
2 B 3
3 C 1
结果应为:
EName MgrName
A B
C A
此结果的Sql查询吗?
An employee table with fields :SlNo,Ename,MgrID.
SlNo EName MgrId
1 A 2
2 B 3
3 C 1
Result should be:
EName MgrName
A B
C A
The Sql query for this Result?
答
SELECT A.EName as EName , B.EName as MgrName FROM employee A INNER JOIN employee B on A.SlNo = B.MgrId
看看SQL 内部加入 [ ^ ]并尝试编写一个查询.
如果仍然没有解决方案，请在此处发布查询，然后有人会为您提供帮助.
Have a look at the SQL Inner Join[^] and try writing a query.
If you still dont get a solution, post your query here and someone will help you.
SELECT A.EName as EName , B.EName as MgrName FROM employee A INNER JOIN employee B on B.SIno= A.MgrID