Chinaunix

标题: 请教一个sql查询语句哈. [打印本页]

作者: racoonwise 时间: 2006-08-01 11:37
标题: 请教一个sql查询语句哈.
subject表
subject_id teacher1_id teacher2_id subject_name
001       01    02    aaa
002       01    bbb
teacher表
teacher_id teacher_name
01 李四
02 张三
期望结果
subject_id teacher1_name teacher2_name subject_name
001 李四张三 aaa
002 李四 bbb
就是查出subject的指定字段的所有内容，然后根据teacher1_id和teacher2_id在teacher表中查出相应的中文名怎么查？
谢谢.

作者: zhang_yong88 时间: 2006-08-01 13:53
??????????

select subject_id ,b.teacher_name teacher1_name ,c.teacher_name teacher2_name, subject_name from subject x ,teacher b, teacher c
where x.teacher1_id =b.teacher1_id(+) and x.teacher1_id =c.teacher1_id (+)

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)