union 的使用

//查询俩个表符合条件的数据，合并数据并区分俩个表的数据

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