How can we acheive correlated sub-query in designer?can anyone help me in this regard?
- 1 Answers
- 1042 Views
- I also Faced
- E-Mail Answers
Answer Posted / Richa Gupta
In ColdFusion, you can achieve a correlated sub-query by using a nested cfquery tag within another cfquery tag. Here is an example:n`n<cfquery name="outerQuery">
SELECT * FROM employees
<cfquery param="id" cfsqltype="CF_SQL_INTEGER">
<!--- Sub-query here --->
</cfquery>n</cfquery>`nnIn this example, the sub-query is correlated because it references a variable (id) from the outer query.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What is the purpose of Dataware Control?
Explain how to generate iqd file from framework manager?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
