ERROR 1064 on IN statement

kromo · #1 (**permalink**) 01-28-04, 09:21

I would like to get a list of "documents" not locked with this statement

Code:

SELECT F_DOCUMENT_ID FROM T_DOCUMENT WHERE F_DOCUMENT_ID  <> ANY ( SELECT F_DOCUMENT_ID FROM T_DOCUMENT_LOCK )

however I get only this error

Code:

[DB] 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 F_DOCUMENT_ID FROM T_DOCUMENT_LOCK )' at line 1

I looked up the MySQL docs, but it seems to be right...
Anyone a clue?

thanks,
kromo

vanekl · #2 (**permalink**) 01-28-04, 12:36

try this,

SELECT f_document_id
FROM t_document d LEFT JOIN t_document_lock c
ON d.f_document_id = c.f_document_id
WHERE c.f_document_id IS NULL

what version of MySQL are you using?
only versions 4.1+ are capable of subselects.

Internet Services

Web Development

Digital Marketing

Consumer Tech