COUNT

[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
how can i fix that?
 
_________________________________________________
Quer ter um fórum para seu clan de Starcraft/BroodWar, Counter-Strike,
Warcraft ou outros. entre em 
http://www.arena-star.com.br/forum/