Help with counting records in atable

[slimdave]

select (select count(*) from employees)+(select count(*) from departments
from dual

One empty table will spoil that for you -- use NVL(count(*),0).

you could also ...

select count(*) from
(
select null from employees
union all
select null from departments
union all
...
)