OraFAQ Forum: Reports & Discoverer » Two different table and two differen column

Home » Developer & Programmer » Reports & Discoverer » Two different table and two differen column

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

Two different table and two differen column [message #366859]

Tue, 28 November 2000 04:29

Karri Lahtela
Messages: 16
Registered: November 2000

Junior Member

Hi!

I have this kind of problem:
In table one I have a column address, If it has a value I must take and store it in variable1. But if it is empty I must take Address2 from table2 and store it in same variable1.
Regards Karri

Report message to a moderator

Re: Two different table and two differen column [message #366869 is a reply to message #366859]

Tue, 05 December 2000 15:18

Madhav Kasojjala
Messages: 42
Registered: November 2000

Member

Hi,
Use SQLFunction "decode" to achieve this
Madhav

Report message to a moderator

Previous Topic:	Report question - help
Next Topic:	Disable Database User Authentication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:39:02 CDT 2024