select a.id,a.`name` AS '姓名',b.`subject`,c.`achievement` from aaa AS a left join ccc AS c on a.id=c.uidleft join bbb AS b on c.sid=b.idwhere a.id in(1,2,3)group by c.achievementhaving c.achievement>=60order by c.achievement desclimit 3
本文共 292 字，大约阅读时间需要 1 分钟。
select a.id,a.`name` AS '姓名',b.`subject`,c.`achievement` from aaa AS a left join ccc AS c on a.id=c.uidleft join bbb AS b on c.sid=b.idwhere a.id in(1,2,3)group by c.achievementhaving c.achievement>=60order by c.achievement desclimit 3
转载于:https://www.cnblogs.com/xj76149095/p/5677451.html