//查询俩个表符合条件的数据,合并数据并区分俩个表的数据
SELECT 'err' partname,time,uid,url,ip,name FROM test1 WHERE uid=9 AND time BETWEEN '2013-03-01 16:25:38' AND '2013-03-01 17:25:38' UNION SELECT 'nor' partname,time, uid,url,ip,name FROM test2 WHERE uid=9 AND time BETWEEN '2013-03-01 16:25:38' AND '2013-03-01 17:25:38' ORDER BY time DESC LIMIT 0,15
//算俩个表的总和
SELECT COUNT(*) FROM (SELECT uid,nam,age,sex FROM test1 WHERE uid=1 UNION SELECT uid,name,age,sex FROM test2 WHERE uid=1)AS t