Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Correlated Subquery????
- Thread starter Sridharan
- Start date
Hello Sri,
BO lets you set up an uncorrelated subquery using the query panel (I suppose this is old news to you). You could modify it into a correlated subquery by modifying the SQL with correlation names and applying the 'do not generate SQL' setting, but you will possibly run into trouble, cause objects retrieved will not comply with the SQL objects.
Last resort is to use a freehand SQL to do the job....
T. Blom
Information analyst
tbl@shimano-eu.com
BO lets you set up an uncorrelated subquery using the query panel (I suppose this is old news to you). You could modify it into a correlated subquery by modifying the SQL with correlation names and applying the 'do not generate SQL' setting, but you will possibly run into trouble, cause objects retrieved will not comply with the SQL objects.
Last resort is to use a freehand SQL to do the job....
T. Blom
Information analyst
tbl@shimano-eu.com
Hi Shri,
It is possible to make correlated queries using Query Panel. It has some limitation but is good when filter on mesaures. In the Query panel when u get the Operand List, you can find one entry Calculation. Follow the wizard and you will be able to build a correlated query.
It is possible to make correlated queries using Query Panel. It has some limitation but is good when filter on mesaures. In the Query panel when u get the Operand List, you can find one entry Calculation. Follow the wizard and you will be able to build a correlated query.
- Thread starter
- #4
- Status