How Can We Acheive Correlated Sub-query In Designer?can Anyone Help M

1.	How Can We Acheive Correlated Sub-query In Designer?can Anyone Help Me In This Regard?
Answer» RIGHT click on any object,go to the properties.specify the QUERY in SELECT and put the next query in where clause, LIKE select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2) Right click on any object,go to the properties.specify the query in select and put the next query in where clause, like select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2)

How Can We Acheive Correlated Sub-query In Designer?can Anyone Help Me In This Regard?

Answer»

RIGHT click on any object,go to the properties.specify the QUERY in SELECT and put the next query in where clause,
LIKE select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2)

Right click on any object,go to the properties.specify the query in select and put the next query in where clause,
like select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2)

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?

How Can We Acheive Correlated Sub-query In Designer?can Anyone Help Me In This Regard?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment