sql_language thread: Combining count(*)s from multiple tables
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
|





