loop inside query

Hi all,

I need to select some fields from three queries.

Can I do a loop inside query of queries?

Here is my code:

<cfquery dbtype="query" name="qryData" >

                select my_ID, my_DESC

                 <cfloop from="1" to="#totalYears#" index="y">

                     ,year_#y#

                 </cfloop>

                from queryA

                union all

                select my_ID, my_DESC

                 <cfloop from="1" to="#totalYears#" index="y">

                     ,year_#y#

                 </cfloop>

                from queryB

                union all

                select my_ID, my_DESC

                 <cfloop from="1" to="#totalYears#" index="y">

                     ,year_#y#

                 </cfloop>

                from queryC

            </cfquery>

Maybe is a better way to do this.

Thanks!