Multiple queries inside each other ?? Possible?

i doing query on table pulls data customers number.  than, on output on screen, need display clients name customers number.  however, clients name inside table under clientsinfo.

 

i need output this:   client number: 123 (john smith)

 

 

this doesn't work below?   idea?

 

<cfquery name="checkclientnumber" datasource="allsales">
         select * clientsales
         clientnumber = '#clientnumber#'
    </cfquery>
  

 

 

 

 

<cfoutput query ="checkclientnumber">client number:  #clientnumber#

 

 

                <cfquery name="client" datasource="clientsinfo">
                        select lastname, firstname clients
                        clientnumber = '#clientnumber#'
                 </cfquery>

 

<cfoutput query="client"> ( #firstname# #lastname# )</cfoutput>

 

 

</cfoutput>

how not work?  errors, wrong data, hums out of tune?

More discussions in Advanced Techniques

adobe