Need to create a BO Report which will have the select statement implemented within the select clause ( enclosed in paranthesis)
For Eg :
select Employee_Name,
(select Address from Geog where Geog.AddrID = Emp.AddrID) Employee_Address,
Emp.Sal Salary
from Employee Emp
Is there any way to define the objects in Universe so as to acheive this?
( Here the SQL needs to be automatically generated, and not to be overriden at WebI level)