Skip to Content
0
Jun 15, 2016 at 08:50 AM

can we take objects from different tables in one block

19 Views

Hi Experts,

i have 3 tables that are joined like below i want the union records in one block.

Table 1

AID

Pname

table 2

BID

EmpName

table3

ID

EmpName

Table1 joined like Table1.AID=table2.BID and Table1.AID=table3.BID but there is no join between table 2 and table3 but i want to show all 3 objects those are(pname from table1 and empname from table 2 and empname from table3 in one block)

i have cretaed 2 queries like Query 1: Pname,Empname and Query2:Pname,EmpDet and merged Pname object and created one detail object for query2.empname and added in one block but the results are showing blank for empname column

is that possible to add when there no join between tables,please let me know