unionの総計を求めたいとき

select sum(count) from
(
select count(`id`) as count from table1
union
select count(`id`) as count from table2
union
select count(`id`) as count from table3
) as union_data
mysqlの場合は、as 別名
をつけないとエラーがでるっぽい

その他