OraFAQ Forum: Reports & Discoverer » Choosing between two values for a field

Home » Developer & Programmer » Reports & Discoverer » Choosing between two values for a field

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

Choosing between two values for a field [message #143457]

Thu, 20 October 2005 09:01

orahugo
Messages: 32
Registered: October 2005
Location: England

Member

Hello,

I have two tables. Table A has a normal price. Table B has an override price. If the normal price is populated the key to Table B is null. If the normal price is not populated the key to Table B is populated. I want to write a query statement that calls the normal price from Table A, and if that is not populated I want to be able to use the key to use the override price from Table B.

Is this possible?

Many thanks.

Report message to a moderator

Re: Choosing between two values for a field [message #143471 is a reply to message #143457]

Thu, 20 October 2005 09:36

kiran
Messages: 503
Registered: July 2000

Senior Member

Just have a look at the below query.I do not have oracle currently.

select nvl(a.normal_price,b.override_price) from a,b where
a.pk=b.fk

Just give a try using this.
--Kiran.

Report message to a moderator

Previous Topic:	oracle report parameters problem
Next Topic:	"rep-0999 Unimplemented Error"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 25 19:50:07 CDT 2024