sql error

From: Stephen <poffs_at_tteam.com>
Date: Mon, 26 Oct 1998 17:01:36 -0500
Message-ID: <712re3$nrf$1@autumn.news.rcn.net>

why do i need a right paren there? I'm totally missing this....someone please point it out to me. thanks.

SQL> select budgetrecapreport_V.Reviewer, budgetrecapreport_V.Communication,   2 budgetrecapreport_V.ProductLine, Sum(budgetrecapreport_V.Budget) AS SumOfBudget1 ,
  3 Sum(budgetrecapreport_V.totalobligations1) AS SumOftotalobligations1,   4 IIf(SumOfBudget1-SumOftotalobligations1 Is Null,0,SumOfBudget1-SumOftotalobligations1)AS SumOfR emaining1,

  5  Sum(budgetrecapreport_V.Labor1) AS SumOfLabor1,
  6  Sum(budgetrecapreport_V.Media1) AS SumOfMedia1,
  7  Sum(budgetrecapreport_V.Printing1) AS SumOfPrinting1,
  8  Sum(budgetrecapreport_V.Production1) AS SumOfProduction1,
  9  Sum(budgetrecapreport_V.Research1) AS SumOfResearch1,
 10  Sum(budgetrecapreport_V.Travel1) AS SumOfTravel1,
 11  Sum(budgetrecapreport_V.Trade1) AS SumOfTrade1

 12 from
 13 budgetrecapreport_V LEFT JOIN budget_reviewerrecap_V ON budgetrecapreport_V.Reviewer = budget_r eviewerrecap_V.Reviewer
 14 group by budgetrecapreport_V.Reviewer, budgetrecapreport_V.Communication,
 15 budgetrecapreport_V.ProductLine
 16 order by budgetrecapreport_V.Reviewer, budgetrecapreport_V.Communication;
IIf(SumOfBudget1-SumOftotalobligations1 Is Null,0,SumOfBudget1-SumOftotalobligations1)AS SumOfRemain

                                                                         *

ERROR at line 4:
ORA-00907: missing right parenthesis

SQL> --

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Stephen E. Poff, Database Developer
TEAM Consulting, Incorporated
http://www.tteam.com/
Voice: (703) 256-6661 x103
Fax: (703) 256-3810
poffs_at_tteam.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Mon Oct 26 1998 - 16:01:36 CST