1.UNION ALL 列出所有的值,允许重复值
方法一:select sum(a) from (select COUNT(*) a from IR union all select COUNT(*) a from HIST_IR) c
方法二:select COUNT(*) from (select IR_ID from IR union all select IR_ID from HIST_IR) c
2.UNION 两个表中IR_ID重复的值只会出现一次
select COUNT(*) from (select IR_ID from IR union select IR_ID from HIST_IR) c
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
备注:UNION 内部的 SELECT 语句必须拥有相同数量的列。列也必须拥有相似的数据类型。同时,每条 SELECT 语句中的列的顺序必须相同。