Re: sql error

Stephen,

     You may want to change line 13 as well. To something like:

budgetrecapreport_V, budget_reviewerrecap_V WHERE budgetrecapreport_V.Reviewer(+) =

      budget_reviewerrecap_V.Reviewer

or

budgetrecapreport_V, budget_reviewerrecap_V WHERE budgetrecapreport_V.Reviewer =

      budget_reviewerrecap_V.Reviewer (+)

...depending if you want an outer or inner join.

Jay!!!

Stephen wrote:

> 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 Tue Oct 27 1998 - 11:23:08 CST