MS SQL Server数据库。
我有这样一个简单的结构:(对于主键不在正确位置的问题,很抱歉)
在TEACHER表中,我有一个外键“Chief”,它引用TEACHER.ID(同一张表)。在进行SELECT查询时,如何获取不是整数(Teacher.ID),而是主任的名称(TEACHER.Name for Chief)?
以下查询只会得到一个整数(主任的ID):
SELECT DEPARTMENT.Name, TEACHER.Name, TEACHER.IDCode, POST.Name, TEACHER.Tel, TEACHER.Salary, TEACHER.Rise, TEACHER.HireDate, Chief
FROM TEACHER, DEPARTMENT, POST
WHERE TEACHER.ID_Post = POST.ID AND
TEACHER.ID_Department = DEPARTMENT.ID;
GO
chief.Name as "Chief Name"
。由于SQL Server也理解这种语法,我更喜欢遵循标准。 - user330315