一条sql语句分别统计出来两张表的数据

http://bbs.csdn.net/topics/380114638

come表，nocome表，分别有字段tid,然后我要从come表和nocome表分别统计出来tid的次数。统计的结果要是这样
|——————————————————————————————————————————————||
|   tid                          count(come.tid)                   count(nocome.tid)
|____________________________________________________________________________________________
|
|
|

select tid,sum(a),sum(b) from ( select tid,count(come.tid) as a,0  as b from come group by tid union all select tid,0 as a,count(nocome.tid) as b from nocome group by tid order by tid) group by tid order by tid     create table come (        tid number(10) );   create table nocome(        tid number(10) );

==================================================================================

自测：

SELECT userid,sum(a)，sum(b) from (
SELECT userid,count(app_customer.userid) as a,0 as b from app_customer GROUP BY userid
UNION all
SELECT userid,0 as a,count(app_product.userid) as b from app_product GROUP BY userid) as total GROUP BY userid

合并 两个表的总数

SELECT userid,sum(a)+sum(b) from (
SELECT userid,count(app_customer.userid) as a,0 as b from app_customer GROUP BY userid
UNION all
SELECT userid,0 as a,count(app_product.userid) as b from app_product GROUP BY userid) as total GROUP BY userid

再排一下序