This discussion is archived
2 Replies Latest reply: Jan 29, 2013 4:37 PM by 987937 RSS

Report on multiple data objects

Suneel Jakka Newbie
Currently Being Moderated
I am not sure, I did this or not.. Is there a way to create a report on multiple data objects? My requirement is as follows

Data_object_A

Field1 Field2 Field3
1 ABC 123
2 DEF 456
3 GHI 789

Data_object_B

Field1 Field2 Field3
1 444 XYZ
2 555 STU

Over here I have a primary key and reference key as first column in the both data objects and I have to create a report by using equi-join..

that means I have to create a report with data from these above two data objects as below

select a.field1,a.field2,a.field3,b.field2,b.field3
from Data_object_A a, Data_object_B b
where a.field1=b.field2(+)

Regards,
Suneel Jakka

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points