using the northwind database in sql server as an example:

select sum(tally) from (
select count(*) tally from employees
union all
select count(*) tally from employeeterritories
union all
select count(*) tally from [order details]) as tblunion

Don

---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com