Report on multiple data objects
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