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更新多个值 时,字段之间用‘,’ 隔开