OraFAQ Forum: SQL & PL/SQL » iif statement in Access

Home » SQL & PL/SQL » SQL & PL/SQL » iif statement in Access

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

iif statement in Access [message #9623]

Mon, 24 November 2003 11:33

Gregg
Messages: 7
Registered: August 2002

Junior Member

how would I convert the following Access query to Oracle?

SELECT IIf(IsNull([[MIS_TOWNCODES]]![[SECONDARYFEED]]),[[MIS_TOWNCODES]]![[PRIMARYFEED]],[[MIS_TOWNCODES]]![[SECONDARYFEED]]) AS headend, Sum(MIS_HE.HHPS) AS SumOfHHPS
FROM MIS_HE INNER JOIN MIS_TOWNCODES ON MIS_HE.FCODE = MIS_TOWNCODES.FRANCODE
GROUP BY IIf(IsNull([[MIS_TOWNCODES]]![[SECONDARYFEED]]),[[MIS_TOWNCODES]]![[PRIMARYFEED]],[[MIS_TOWNCODES]]![[SECONDARYFEED]]);

Report message to a moderator

Re: iif statement in Access [message #9669 is a reply to message #9623]

Fri, 28 November 2003 09:48

Dave
Messages: 92
Registered: August 1999

Member

I'm not sure about the join but the NVL function should take care of the fields/columns:

SELECT NVL(MIS_TOWNCODES.SECONDARYFEED,MIS_TOWNCODES.PRIMARYFEED) HEADEND, SUM(HHPS)
FROM MIS_HE, MIS_HE
WHERE MIS_HE.FCODE = MIS_HE.FRANCODE (+)
GROUP BY NVL(MIS_TOWNCODES.SECONDARYFEED,MIS_TOWNCODES.PRIMARYFEED)

Report message to a moderator

Re: iif statement in Access [message #9670 is a reply to message #9669]

Fri, 28 November 2003 11:08

Gregg
Messages: 7
Registered: August 2002

Junior Member

Thank You. That worked Perfectly!!!

Report message to a moderator

Previous Topic:	PACKAGE COMPILED IN ORACLE 8i BUT GIVING ERROR IN 9i
Next Topic:	clob display problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:53:30 CDT 2024