query of a query?

[Bing Du]

The following are Cold Fusion code.  It's interesting that previously
defined queries can be used as 'tables' to pull data from.  In MySQL, does
the same functionality have to be implemented using join or subselect?

=======
<CFQUERY name="getprojects" datasource="#dbname#">
                        SELECT     db_entry_num, title
                        FROM       account_info
        </CFQUERY>

<CFQUERY name="getprojectID" datasource="#GSN#">
        SELECT projectID
        FROM ResearchProjects
        WHERE IDNo = #url.IDNo#
        </cfquery>

<cfif getprojectID.recordcount GT "0">
        <!--- Query of a query --->
                <cfquery dbtype="query" name="getstudproj">
                SELECT title, db_entry_num, projectID
                FROM getprojects, getprojectID
                WHERE        db_entry_num = projectID
                </cfquery>
        </cfif>
=========

Thanks,

Bing

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]