PHP DB - MySQL Subquery problems...

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MySQL Subquery problems...

Scott V Nipp

2005-03-30, 3:56 pm

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@sbc.com
Web: http:\\ldsa.sbcld.sbc.com

Sponsored Links