If we want to Calculate Sum of 2 tables count we can use following query
SELECT SUM(c)
FROM (
SELECT COUNT(id) AS c FROM table1
UNION ALL
SELECT COUNT(id) FROM table2
) as b
SELECT SUM(c)
FROM (
SELECT COUNT(id) AS c FROM table1
UNION ALL
SELECT COUNT(id) FROM table2
) as b
No comments:
Post a Comment