List:General Discussion« Previous MessageNext Message »
From:Kiss Dániel Date:June 6 2002 7:47pm
Subject:Re: sub-queries
View as plain text  
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 <mysql-thread111241@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-niel=mailbox.hu@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
sub-queriesChris Knipe6 Jun
  • Re: sub-queriesKiss Dániel6 Jun
    • Re: sub-queriesChris Knipe6 Jun
      • RE: sub-queriesCal Evans6 Jun
  • Re: sub-queriesSabine Richter6 Jun
  • Re: sub-queriesChris Knipe6 Jun
  • Re: sub-queriesChris Knipe6 Jun
    • RE: sub-queriesKevin Fries7 Jun
      • Re: sub-queriesChris Knipe7 Jun
        • Re: sub-queriesBenjamin Pflugmann7 Jun
      • Re: sub-queriesChris Knipe7 Jun
        • Re: sub-queriesBenjamin Pflugmann7 Jun