Question

JFinal的分页语句，怎么在sql中写UNION

Answer 1

JFinal的分页语句，怎么在sql中写UNION
select * from ( (SELECT a,b,c FROM tbl_name WHERE a=10 AND B=1)
UNION
(SELECT a,b,c FROM xxx_name WHERE a=11 AND B=2)
ORDER BY a LIMIT 10);