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

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