Fair enough (and also what I thought).... Does anyone have any idea how I can implement the below in a similar "fashion" then?
I have a list of items, and a list of groups. I want to retrieve all the items from a table that is not in a specific group... ----- Original Message ----- From: "Kiss Dániel" <[EMAIL PROTECTED]> To: "Chris Knipe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 06, 2002 9:47 PM Subject: Re: sub-queries > 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