Rick Lang (6/21/2010)
Perhaps a different version of the question where the answer would be different with the Having clause vs just the where clause might help to clear up any confusion (mine anyways)?
In addition to Hugo's example, this is a favourite of mine:
SELECT 'One row'
WHERE 1 = 0
HAVING 0 = 0;
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi