sc是table,s是编号,c是课程
select * from sc A left join sc B on A.s=B.s left join sc C on A.s=C.s where A.c=B.c and A.c=C.c (其余条件放Where后面)
Mysql left join 多表格多条件解决方案
最新推荐文章于 2024-05-14 17:07:48 发布
sc是table,s是编号,c是课程
select * from sc A left join sc B on A.s=B.s left join sc C on A.s=C.s where A.c=B.c and A.c=C.c (其余条件放Where后面)