I would like to get a list of "documents" not locked with this statement
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
[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?