George Cole
Member since May 14, 2010
- Profile: /members/6034-george-cole.htm
- URL: http://www.fireantstudios.co.uk/
- Comments: 1
Recent Blog Comments By George Cole
-
Getting Group By Count In Left Outer Join
Posted on May 14, 2010 at 10:51 AM
This SQL isn't syntatically correct as ISNULL() only takes 1 parameter. I would suggest something along the lines of: IF( ISNULL( COUNT(r.id)), 0, COUNT(r.id) ) AS reward_count... read more »