What's wrong with this?

My mysql statement does not work. It gives me the following error:

user error: 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 simpleNodeName.nid FROM simpleNodeName)' at line 1
query: SELECT * FROM node where node.nid IN (SELECT simpleNodeName.nid
FROM simpleNodeName) in
/home/blapper/public_html/includes/database.mysql.inc on line 66.

My mysql version is : 4.0.25-standard

The sql is

SELECT * FROM node where node.nid IN (SELECT simpleNodeName.nid FROM
simpleNodeName)

Could anyone help me fix this. I've read the mysql documentation but
it hasn't enlightenned me

.

Relevant Pages

  • Re: Error connection Clarion 5.5G and MySQL
    ... I work with Clarion 5.5G and MSACCESS databases. ... I like to change my MSACCESS database to MYSQL 5.0 database, ... when I select a client I blocked this client for security and use a ... Error (You have an error in your SQL syntax: ...
    (comp.lang.clarion)
  • Re: Problem with apostrophe in MySQL
    ... "You have an error in your SQL syntax; ... corresponds to your MySQL server version for the right syntax to use ...
    (alt.php)
  • Re: Connecting MS Project 2003 Pro to a MySQL 5 database with MyOD
    ... perhaps in the spirit of MySQL start an open source project to do so? ... kevin wrote: ... I am trying to connect MS Project Professional 2003 to a MySQL 5 database but it doesn't work. ... I don't think it comes from the ODBC, but from the SQL syntax: ...
    (microsoft.public.project)
  • Re: Auslesen, in welchem Feld der Treffer steckt
    ... Als SQL-Fehlermeldung erhalte ich: ... Fehlermeldung=You have an error in your SQL syntax near '(select 01, ... Zweite Variante ist, dass dein String, den du an MySQL sendest vorher schon gefüllt war und du nur erweiterst. ...
    (de.comp.datenbanken.mysql)
  • Re: MAINFRAME SHOP STANDARDS
    ... with a pretty nice drawing tool (I've used it to create database ... from the M/F IDE I generate SQL syntax and do a ... > copy and paste into COBOL source. ... MySQL has some new tools that let you develop the query against your ...
    (comp.lang.cobol)