SQL query returning wrong results

1

I have this table in my datatbase

  "CREATE TABLE \(tableNAME)  ("
        + " GameID      Integer,"
        + " TimesPlayed Integer Default 0,"
        + " TimesWon    Integer Default 0,"
        + " isFavorite  Boolean Default False)"

currently only TWO records have isFavorite marked as true, ALL values of TimesPlayed and Times Won are ZERO

SELECT a.gameid,a.gametitle,a.iconname, IFNULL(b.isFavorite,false) as isFavorite, IFNULL(b.timesPlayed,0) as timesPlayed, IFNULL(b.timesWon,0)    as timesWon 
FROM Lookup a  
LEFT JOIN  Favorites  b    
ON a.gameID=b.gameID 
ORDER BY a.gameTitle

This query returns ALL records in “lookup” as required (there is no “WHERE”)

Adding this to the above gives me the two marked Favorites

WHERE isFavorite=true

however so does using this as the WHERE

WHERE timesPlayed=0

It should return ALL records as everyone has timesPlayed as ZERO, not just the two favorites

This final WHERE returns the correct values (ie. ZERO records)

WHERE timesPlayed>0

So >0 returns no records (correct) but =0 return only TWO?

FYI… I have validated that the values of every field is correct

2

DUH!
Since it is a join with lookup, any record in lookup that is NOT in favorites will get a NULL values (hence the IFNULL statements)

But those IFNULL DO NOT APPLY to the WHERE statements!

by adding them to the WHERE clause as well, it now works