Re: [uug] What is an SQL subselect?

[Andrew Jorgensen]

The best information I've found on subselects and what MySQL can't do is here <http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html>. I have to admit I find it hard to do complex queries without subselects, but it's possible, and now that MySQL 4 is stable I don't have to worry much about that.

Basically a subselect is where you use a select statement as the data source for another select statement, rather than a table or tables.

Phillip Hellewell wrote:

Hi,
        I'm planning to write a PHP/MySQL budget manager.  I seem to
remember hearing something about MySQL's inability to do subselects.
What exactly _is_ a subselect?  Is it like a join?
        Anyway, I'd hate to get almost finished and then realize I can't do
what I want because no subselects.  If I need them I'll just use
PostgreSQL from the start.

Thanks,
Phillip

P.S.  No, I haven't taken CS 452 yet :)  (But I did some database
programming 7 years ago.)

--
Andrew Jorgensen

smime.p7s
Description: S/MIME Cryptographic Signature

____________________
BYU Unix Users Group 
http://uug.byu.edu/ 
___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list