Eclipse Community Forums: BIRT » Problem with Data Set (Oracle DB)

Home » Archived » BIRT » Problem with Data Set (Oracle DB)

Problem with Data Set (Oracle DB) [message #60153]

Wed, 20 July 2005 06:49

Eclipse User

Hi everyone,

I have two tables in Oracle DB:

Table1 (4 columns)
Id
String
Id_1
Id_2

Table2 (2 columns)
Id
String

Id_1 and Id_2 are id from different rows in Table2.

I write a Data Set

select table1.id as col1,
s1.string as col2,
s2.string as col3
from table1,
table2 s1,
table2 s2
where
s1.id=table1.id_1
and
s2.id=table2.id_2

and I've got

Col1 Col2 Col3
A A1 A1

when I should get

Col1 Col2 Col3
A A1 B1

I run this statement in Oracle client & DBEdit plugin and everythig is fine.
Can someone explain me what is wrong with this Data Set?

Thanks,
Anak

Previous Topic:	Problem with BIRT script
Next Topic:	birt: detail rows with different column layout ?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jun 04 02:45:07 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter