COUNT

2004-05-16 Thread Gustavo Andrade
select count(distinct membros.ID) as total_membros, count(distinct replays.ID) as total_replays, count(distinct downloads.ID) as total_downloads from membros,replays,downloads; if one of the tables have 0 records all the counts will turn to 0 the count works only if all the tables have records ho

Counting multiple tables

2004-05-16 Thread Gustavo Andrade
I want to know if its possible to count the total records of multiple tables: Example: I have 3 tables. I want to know the total records of each table using only 1 query. Is that possible? _ Quer ter um fórum para seu clan de Starcraft/BroodWar, C