I am attempting to write data to an html table from three different Access
tables. I have three (3) queries in the cftransaction, each later query
dependent on the previous query. I need to output data latter two tables into
the html table. But I am getting the following error:

Invalid tag nesting configuration.
A query driven CFOUTPUT tag is nested inside a CFOUTPUT tag that also has a
QUERY= attribute. This is not allowed. Nesting these tags implies that you want
to use grouped processing. However, only the top-level tag can specify the
query that drives the processing.

Here is the code:

<cftransaction>
<cfquery name="get_open_requests" datasource="storage">
SELECT request_id FROM status WHERE status_id=1
</cfquery>
<cfquery name="open_request_info" datasource="storage" >
SELECT * FROM requests WHERE request_id=#get_open_requests.request_id# ORDER
BY request_id
</cfquery>
<cfquery name="get_requestor_info" datasource="storage">
SELECT * FROM requestors WHERE requestor_id=#open_request_info.requestor_id#
</cfquery>

</cftransaction>

<table align="center" border="1" cellpadding="5" cellspacing="0">
<tr>
<td><strong>ID</strong></td>
<td align="center"><strong>Request Time</strong></td>
<td align="center"><strong>Name</strong></td>
<td><strong>Lehigh ID</strong></td>
<td align="center"><strong>Email</strong></td>
<td><strong>Title</strong></td>
<td><strong>Author</strong></td>
<td><strong>Call Number</strong></td>
<td>&nbsp;</td>
</tr>
<cfoutput query="open_request_info"><cfoutput query="get_requestor_info">
<tr><form action="view_request" method="get">
<td>#request_id#</td>
<td>#request_time#</td>
<td>#firstname#&nbsp;#lastname#</td>
<td>#LIN#</td>
<td>#email#</td>
<td>#title#</td>
<td>#author#</td>
<td>#callnum#</td>
<td><input name="request_id" type="hidden" value="#request_id#"><input
name="view" type="submit" value="view request"></td></form>
</tr></cfoutput></cfoutput>
</table>