Problem Statement –
How to display data from more than one table in to AF:Table.
There are EOs based on tables EmpEO, DeptEO and i would like to display a table with,
Emp Name, Emp Manager Name and Emp Department Name.
Emp Manager Name can be taken from inner join with EMP Table.
Emp Department Name can be taken from DeptEO with Left Join.
1. Create a VO based on two EO i.e. EmpEO and DeptEO.
2. Update VO Query as,
From Emp E, Emp E1, Dept D
E.EmpId = E1.EmpId AND
E.DeptId = D.DeptId(+)
3. Drag VO from Data Control and create table.