List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:June 6 2002 7:39pm
Subject:sub-queries
View as plain text  
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


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