Question

sql 对2张表的1列数据计数，sql语句怎么写？

Answer 1

SELECT FPHM,计数手枣=CASE WHEN COUNT(1)<毕滑拆=2 THEN 2 END FROM
(SELECT * FROM 表1
UNION
SELECT * FROM 表2 ) A
GROUP BY FPHM
UNION
SELECT FPHM=‘合计’让厅,计数=COUNT(DISTINCT FPHM) FROM
(SELECT * FROM 表1
UNION
SELECT * FROM 表2 ) B

追问

是我没说清楚，大牛给我的太复杂了，我要的查询结果只要：
fphm
1001
1002
1003
1001
1002
1004
这样就行，也就是说把2个表接起来就OK。

追答

SELECT * FROM 表1
UNION
SELECT * FROM 表2

Answer 2

select count(*) as 总数绝缓量丛宏穗渗卜
from
(select fphm from t1
union
select fphm from t2
)as t