bobajobrob
ISP
Hi,
I'm trying to run the following query:
SELECT DISTINCT DataRecordID FROM ShortTextData WHERE NOT EXISTS (SELECT ContentElementID FROM ContentElements WHERE ShortTextData.ContentElementID=ContentElements.ContentElementID)
MySql is saying:
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]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 'EXISTS (SELECT ContentElementID FROM ContentElements WHERE Shor
What's going on here? I was under the impression that 4.0.14 supports sub queries. Am I missing something?
Cheers,
Rob Shields
I'm trying to run the following query:
SELECT DISTINCT DataRecordID FROM ShortTextData WHERE NOT EXISTS (SELECT ContentElementID FROM ContentElements WHERE ShortTextData.ContentElementID=ContentElements.ContentElementID)
MySql is saying:
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]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 'EXISTS (SELECT ContentElementID FROM ContentElements WHERE Shor
What's going on here? I was under the impression that 4.0.14 supports sub queries. Am I missing something?
Cheers,
Rob Shields