Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Combining count(*)s from multiple tables


Message #1 by "Elizabeth Gusztak" <elizabeth.gusztak@e...> on Fri, 6 Apr 2001 20:56:28
Thank you, Imar, that works beautifully.

> How about this:
> 
> Select ((Select Count(*) from Table1) + (Select Count(*) from Table2))
> This will return the sum of the number of records for both tables.
> 
> Still, two select count queries are executed, but I think that's also 
the 
> case when executing a join or a union.
> 
> Hope this helps,
> 
> Imar

  Return to Index