Subject Count over multiple tables
Author williamvdw2004
I would like to get the total number of records for 2 tables combined.

This is as far as I got:

SELECT COUNT(*) FROM TBL1 UNION SELECT COUNT(*)
FROM TBL2;

This gives me 2 rows one with the number of records in TBL1 and one
with the number of records in TBL2. How can I add these values?

Regards
William