急求一sql语句。

Question

SELECT BasicInf.EmployeeID AS 编号, BasicInf.EmployeeName AS 姓名, 
      EmployeeShift.ShiftClassCode AS 班类代码, 
      ShiftClassDef.ShiftClassName AS 班类
into A
FROM BasicInf INNER JOIN
      EmployeeShift ON BasicInf.EmployeeID = EmployeeShift.EmployeeID INNER JOIN
      ShiftClassDef ON EmployeeShift.ShiftClassCode = ShiftClassDef.ShiftClassCode

Answer 1

SELECT BasicInf.EmployeeID AS 编号, BasicInf.EmployeeName AS 姓名, 
      EmployeeShift.ShiftClassCode AS 班类代码, 
      ShiftClassDef.ShiftClassName AS 班类
into A
FROM BasicInf INNER JOIN
      EmployeeShift ON BasicInf.EmployeeID = EmployeeShift.EmployeeID INNER JOIN
      ShiftClassDef ON EmployeeShift.ShiftClassCode = ShiftClassDef.ShiftClassCode