List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:June 6 2002 8:16pm
Subject:Re: sub-queries
View as plain text  
*MWAH*!!!!!!!!!!!

Thanks a million, tested and working beautifully.... Can't believe in two
days I didn't think of this...

--
me


----- Original Message -----
From: "Sabine Richter" <sabine@stripped>
To: "Chris Knipe" <savage@stripped>
Cc: <mysql@stripped>
Sent: Thursday, June 06, 2002 10:14 PM
Subject: Re: sub-queries


> SELECT monitorhosts.HostID
> FROM monitorhosts, monitorhostgroupdetails
> WHERE monitorhosts.HostID =  monitorhostgroupdetails.HostID
> AND monitorhostgroupdetails.HostGroupID != '1');
>
> Gruss
> Sabine
>
> Chris Knipe 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-sabine=textraeume.de@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