Incorrect usage of UNION and ORDER BY mysql 使用union关联查询结果报错

想将两个select查询结果合并在一起

select *
from student_lzc a left join score_lzc b on a.s_id = b.S_id and b.c_id = 01
ORDER BY b.s_score Desc
limit 1,2
union 
select *
from student_lzc a left join score_lzc b on a.s_id = b.S_id and b.c_id = 02
ORDER BY b.s_score Desc
limit 1,2

先看一下单独运行

如果直接使用union运行会直接报错错误信息如下：

select *
from student_lzc a left join score_lzc b on a.s_id = b.S_id and b.c_id = 01
ORDER BY b.s_score Desc
limit 1,2
union 
select *
from student_lzc a left join score_lzc b on a.s_id = b.S_id and b.c_id = 02
ORDER BY b.s_score Desc
limit 1,2
> 1221 - Incorrect usage of UNION and ORDER BY
> 时间: 0.004s

所以要想实现将两个select的结果输出，则可使用将union前后两个查询语句用括号包裹起来