试试
sql =" select * from (";
sql =sql + "Select aID as dbID,aName as dbName from ms_a";
sql = sql + " UNION all select BID as dbID,bName as dbName from ms_b";
sql = sql + " ) aaa order by aaa.dbName desc limit " +(pages - 1) * countPerPage + ","+countPerPage+"";
sql =" select * from (";
sql =sql + "Select aID as dbID,aName as dbName from ms_a";
sql = sql + " UNION all select BID as dbID,bName as dbName from ms_b";
sql = sql + " ) aaa order by aaa.dbName desc limit " +(pages - 1) * countPerPage + ","+countPerPage+"";
试试
sql =" select * from (";
sql =sql + "Select aID as dbID,aName as dbName from ms_a";
sql = sql + " UNION all select BID as dbID,bName as dbName from ms_b";
sql = sql + " ) aaa order by aaa.dbName desc limit " +(pages - 1) * countPerPage + ","+countPerPage+"";这个少了一个as吧?as aaa,不过就是加上了也是报错,mysql可能不支持吧,我用的4,0的,甲骨文就支持这样的