I'm sorry to disappoint you, but subqueries are NOT supported int any MySQL
version, yet.
You can read the MySQL manual about it. You can find there when and how it
will be implemented.
Bye
Daniel
At 21:39 2002.06.06. +0200, you wrote:
>Lo all,
>
>are sub-queries supported on mysql-max 3.23.49 ??
>
>If they are, what's wrong with the following statement?
>
>SELECT monitorhosts.HostID
> FROM monitorhosts
> WHERE monitorhosts.HostID NOT IN
> (SELECT HostID
> FROM monitorhostgroupdetails
> WHERE monitorhostgroupdetails.HostGroupID='1');
>
>mysql complains about a syntax error right at the begining of the second
>select...
>
>ERROR 1064: You have an error in your SQL syntax near 'SELECT HostID
> FROM monitorhostgroupdetails
> WHERE monitorh' at line 4
>
>ty
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
