nesting output from 2 queries

[Tim Laureska]

If you have two different queries and you want to put the output of one
of those queries within the other, is that possible, if so how (group
processing doesn't appear to be an option)?  Such as:

<cfquery datasource="DSN" name="query1">
SELECT fields_various
FROM  table1
/cfquery>

<cfquery datasource="DSN" name="query2">
SELECT columns_various
FROM table2
</cfquery>

<cfoutput query="query1">
#fields_various#

<cfoutput query="query2">
#columns_various#
</cfquery>

</cfoutput>

TIA
Tim

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---