select distinct Teacher.TeacherID,
Teacher.SurName,Teacher.LastName,
Department.Department, StaffRoom.StaffRoom,
Teacher.Attribution,Teacher.Inservice
from Teacher,Department,StaffRoom
where Department.DepartmentID =Teacher.DepartmentID and StaffRoom.StaffRoomID =Teacher.StaffRoomID
Teacher.SurName,Teacher.LastName,
Department.Department, StaffRoom.StaffRoom,
Teacher.Attribution,Teacher.Inservice
from Teacher,Department,StaffRoom
where Department.DepartmentID =Teacher.DepartmentID and StaffRoom.StaffRoomID =Teacher.StaffRoomID
解决方案 »
- SQL关于时间的查询
- 怎样格式化字符串?
- MS SQL中如何判断指定路径的DAT文件是否存在?
- 有难度的替换!请高手帮忙!
- 字段类型是text,打开数据表显示<Long Text>,如何把显示<Long Text>的内容更新为“同意”两字
- SQL SERVER 2008登陆错误,不管用什么账号登陆都出错,但远程其他的数据库没问题。
- 请教一个SQL语句,一个表的列数据怎么转换为字段名出来?
- sql 中的段时间查询
- 如何运用sql本地包把每个月的txt文件自动导入对应的月表中
- 高手请问?
- 急:怎样从一个表中找出某字段记录为<NULL>的情况?
- 那位大哥帮忙解释一下Northwind示例数据库中的问题
^_^