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
