Skip to Content
0
Former Member
Jun 02, 2011 at 12:49 PM

Select within the Select Clause in BO

623 Views

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)