select name,title
from instructor natural join teaches natural join course
where teaches.course_id = course.course_id;;逗号出现错误,在线求解,万恶的伸手啊
from instructor natural join teaches natural join course
where teaches.course_id = course.course_id;;逗号出现错误,在线求解,万恶的伸手啊
select name,title
from instructor natural join teaches , course
where teaches.course_id = course.course_id;;
SQLServer没你那种语法,用这个
select name,title
from teaches join course
where teaches.course_id = course.course_id;;--这个分号去掉,一个就可以了
from teacher a inner join teacher b on a.主键=b.主键
inner join 其他表 c on a.主键=c.主键
不好意思太高级我看不懂,只是初学者,我就请教你一个问题为了不麻烦你,水平相差太大,我就是想知道t-sql没有natural join 这种语句吗,或者t-sql的自然连接是其他语句
我上次看精品去找本数据库系统概念,里面是通用的sql,没法在sql sever实现真是悲哀啊
from teacher a,teacher b,course c
where a.主键=b.主键 and a.course_id=c.course_id生病了,睡觉,不能理解的话明天请早,或者等别人吧
我等找本t-sql的书重新看吧谢谢哈