(SELECT StaffID AS '员工编号',StaffName AS '员工姓名',Sex AS '性别',Identitycard AS '身份证',NowDeptID AS '在职部门编号',Dept.DeptName AS '在职部门名称',Classinfo.ClassName AS '住宿情况',Classinfo.ClassName AS '学历',Phone AS '电话',Addres AS '地址',Email AS '电子邮件',Remark AS '备注' FROM Staffinner join Dept ON Staff.NowDeptID=Dept.DeptIDinner join ClassInfo ON S... |