Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we acheive Correlated sub-query in Designer?

Answer Posted / prabha

A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the
outer query. This is the main difference between a
correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run
independently of the outer query, and will return a result
set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by
itself.

Is This Answer Correct ?    5 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2073


What would you consider as your biggest achievement and why?

958


how get the grand total in master-detail report?

2172


Explain what are the measure objects?

932


What is a fantrap in business objects?

1101


How to execute the plsql procedure from the report by clicking with mouse?

1070


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1785


What is the difference in creating filters in designer and business objects?

977


What is difference between webi and infoview?

1158


8. How much supervision have you typically received in your previous job?

2201


Explain how we drill up week to month?

1039


How to schedule the report in b.o?

949


Which versions are used in the bo dashboard work?

979


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2390


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1054