Same value in 2 different colums

Jayalakshmi_Mohan

Hi,

I am trying to exeute the below query in Oracle DB,

select a.Id,a.valstr,b.dataID,b.name,c.valstr from
(select ID,valstr from llattrdata where defID=1356613 and attrID=50) a 
Inner join (select dataID, name from dtree where subtype=144 ) b on b.dataID in (Select dataID from dtreeancestors where ancestorid in (a.Id))
Inner join (select ID,valstr from llattrdata where defID=1356613 and attrID=49 and valstr in ('3982 ','3972 ')) c on a.Id =c.ID

But the output of c.valstr is copied to a. valstr and the output looks like below, actually a.valstr is a differnt value which is getting overwritten.

ID   VALSTR   DATAID   NAME   VALSTR   1786213   3972    1784203   Safety Conversation Summary   3972    3367802   3972    3366481   Initial Incident Form   3972

Can someone help with this ?

Thanks

 

Hans Stoop

Oracle or LiveReport gets confused when you return to columns with the same name.

You should change the query to

select a.Id,a.valstr attr50,b.dataID,b.name,c.valstr attr49 from

….

 

Hans

 

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Mittwoch, 30. Januar 2019 09:14
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Same value in 2 different colums

 

Same value in 2 different colums

Posted byjayalakshmi.mohan@accenture.com (Mohan, Jayalakshmi) On 01/30/2019 03:11 AM

 

Hi, I am trying to exeute the below query in Oracle DB, select a.Id,a.valstr,b.dataID,b.name,c.valstr from (select ID,valstr from llattrdata where defID=1356613 and attrID=50) a  Inner join (select dataID, name from dtree where subtype=144 ) b on b.dataID in (Select dataID from dtreeancestors where ancestorid in (a.Id)) Inner join (select ID,valstr from llattrdata where defID=1356613 and attrID=49 and valstr in ('3982 ','3972 ')) c on a.Id =c.ID But the output of c.valstr is copied to a. valstr and the output looks like below, actually a.valstr is a differnt value which is getting overwritten.  ID   VALSTR   DATAID   NAME   VALSTR   1786213   3972    1784203   Safety Conversation Summary   3972    3367802   3972    3366481   Initial Incident Form   3972   Can someone help with this ? Thanks

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	My Support