How can we acheive Correlated sub-query in Designer?
Answers were Sorted based on User's Feedback
Answer / 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 |
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
WHAT IS SAP BO AND BO?
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
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
What are the types of errors you faced while creating a report from two different data providers
WHO ARE THE USERS OF THE REPOSITORY?
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
In banking domain how many Fact tables,Dimension table are present?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?