select s.sn,c.cn,c.cg,t.tn
from s
left join c
on s.sid=c.sid
left join t
on c.cid=t.cid
where c.cg>=60
and tn='陈老师'
from s
left join c
on s.sid=c.sid
left join t
on c.cid=t.cid
where c.cg>=60
and tn='陈老师'

被折叠的 条评论
为什么被折叠?