Subject | Count over multiple tables |
---|---|
Author | williamvdw2004 |
Post date | 2004-12-01T08:14:44Z |
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
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