Re: query of a query?

2006-05-05 Thread Bing Du
> Not necessarily. I would think the CREATE SELECT statement would be > the closest equivalent. > > http://dev.mysql.com/doc/refman/4.1/en/create-table.html > Thanks much for the reply, John. That surely would help with our future applications. But this time, we only have read access to the

Re: query of a query?

2006-05-04 Thread John Hicks
Bing Du wrote: The following are Cold Fusion code. It's interesting that previously defined queries can be used as 'tables' to pull data from. === SELECT db_entry_num, title FROM account_info SELECT projectID

query of a query?

2006-05-04 Thread 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? === SELECT db_entry_num, title