使用一条sql查询多个表中的记录数

方法二：

select sum(t.num1),sum(t.num2),sum(t.num3) from (
    select count(*) num1,0 as num2,0 as num3 from table1 
  union 
    select 0 as num1,count(*) num2,0 as num3 from table2
  union 
    select 0 as num1,0 as num2,count(*) num3 from table3
) t

使用一条sql查询多个表中的记录数

标签：code   count   color   font   from   ble   union   多个   sql