1.子查询里写了order by 例如:select * from A WHERE id in (select aid from B order by id) 解决方案去掉子查询里的order by id 2.全少反括号