# How do I use a Coldfusion query in an SQL Statement?

**URL:** <https://forum.kirupa.com/t/how-do-i-use-a-coldfusion-query-in-an-sql-statement/163582>\
**Category:** web dev\
**Created:** [September 23, 2005, 3:20pm UTC](https://forum.kirupa.com/t/how-do-i-use-a-coldfusion-query-in-an-sql-statement/163582 "2005-09-23T15:20:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kdavis](https://avatars.discourse-cdn.com/v4/letter/k/cdc98d/32.png) [@kdavis](https://forum.kirupa.com/u/kdavis)\
**Post date:** [September 23, 2005, 3:20pm UTC](https://forum.kirupa.com/t/how-do-i-use-a-coldfusion-query-in-an-sql-statement/163582/1 "2005-09-23T15:20:10Z")

</div>

I created a coldfusion query called “drilldown”. On the same page, I need to run another query that uses information from the drilldown query. How can I do this?

Here is my statement right now but it gives me errors saying that it cannot find the drilldown query:

\<cfquery name=“simartist” datasource=“indieworld.mdb”\>  
select bands.bands\_name, bands.bands\_id, #drilldown.similar\_bands\_id#, similar.similar\_simbandsid  
from bands, similar, #drilldown#  
where bands.bands\_id = similar.similar\_simbandsID  
\</cfquery\>