Re: Problem with COUNT in the statement JOIN

[Chevy Mark Sunderland]

I'd appreciate your help so very much.

This is the problem, your observation:

How many records the query produces ?
Answer - 64.
Therefore count(*) gives 64.

Why if I try the statement count with join gives 54 records produce ?

SELECT  
  COUNT(*) `total`
FROM myfirsttablemysql
 WHERE (YEAR(`myDatesYYYYMMDD`)='2011') ;

Try this please... thanks



Edited 1 time(s). Last edit at 02/25/2012 04:29PM by Chevy Mark Sunderland.