想将两个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前后两个查询语句用括号包裹起来