就是union all连接
并用一个查询将多个查询包起来
select sno,station from
(
select sno,station from FLOW where sno = 'DD8' and station = 'RL-2' order by modifydate desc
union all
select sno,station from FLOW where sno = 'DD8' and station = 'FINAL4' order by modifydate desc
)a