SQL语句---多表联查、改、删

SQL语句—多表联查、改、删

1.多表联查

select* 
from Student t1 inner join Teacher t2 on t1.no=t2.no
where t2.Tname='Mimo_YY'

2.多表联改

update t1
set t1.Sname='Mimo_YY',t1.Sage='16'
from Student t1 inner join Teacher t2 on t1.no=t2.no
where t2.Tname='Mimo_YY'

3.多表联删

delete t1
from Student t1 inner join Teacher t2 on t1.no=t2.no
where t2.Tname='Mimo_YY'

写法需要注意的点：

• update、delete后加表名
• update更新多个值 时，字段之间用‘，’ 隔开