IFNULL in QoQ

Can you use the IFNULL statement is QoQ: i.e. SELECT IFNULL( SUM( awardPoints - pointsRedeemed ) , 0) AS Points FROM   qryTmp.memberPoints.orderedMemberData i get this errro: Error Executing Database Query. Query Of Queries syntax error. Encountered "(. Incorrect Select Statement, Expecting a 'FROM', but encountered '(' instead, A select statement should have a 'FROM' construct. TIA -- Nick Tong web:         http://talkwebsolutions.co.uk blog:         http://succor.co.uk short urls: http://wapurl.co.uk linkedin:    http://linkedin.com/pub/0/a70/502