Afficher un message
Vieux 21/04/2006, 11h31   #1
trihanhcie@gmail.com
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut (Mysql 3.23] Query with SUM wrong

Hi,

Well the following query is not the one i will use but it's the same
prob :

SELECT sum(country_id ) , count( country_id )
FROM Tbl_Country, Tbl_config
WHERE country_id =1

Well ...the result should be sum(country_id )= 1 et count( country_id
) = 1... but I have :
sum(country_id )= 4 et count( country_id ) = 4...
The number of entries in Tbl_Config is also 4.... I know that adding
Tbl_config behind is useless but it was just a test... How come i don't
have 1 and 1 as result?

Thanks

  Réponse avec citation
 
Page generated in 0,05091 seconds with 9 queries