MySQL Subquery problems...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



	I am working with one of our Oracle DBAs to have him try and
help me get a couple of queries working.  The problem is that in looking
at the documentation for MySQL it seems that what we are attempting
should work.  Unfortunately, it doesn't.  Here is what we are trying...

mysql> SELECT CPU_Hostname FROM AllMid_Data
    -> WHERE CPU_Hostname NOT IN
    -> (SELECT hostname FROM exclusion);
ERROR 1064: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT hostname FROM exclusion)' at line 3

	This is an error returned from the mysql client.  Any help would
be most appreciated.

Scott Nipp
Phone:  (214) 858-1289
E-mail:  sn4265@xxxxxxx
Web:  http:\\ldsa.sbcld.sbc.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux