#内连接
select * from user as u inner join class as c where u.uid = c.id
#外连接
#左外连接
select * from user as u left join class as c on u.uid = c.id
#右外连接:
select * from user as u right join class as c on u.uid = c.id
#全外连接(mysql不支持):
select * fro, user as u full join class as c on u,uid = c.id
sql多表联查
最新推荐文章于 2024-07-25 15:45:16 发布