(SELECT a FROM t1 WHERE a=10 AND B=1)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2)
ORDER BY a LIMIT 10;

select * from
(select * from tbl1
union all
select * from tbl2
) a
order by col1