williamvdw2004 wrote:

>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?
>
>
>

select count(*) + (select count(*) from tb_tb2)
from tb_tb2