select where not in problem

[Niv3k]

I have two tables tDocumentsCommon and tDocumentExceptions. This is my query:

mysql> select * from tDocumentsCommon Where DocumentID NOT IN (SELECT DocumentID FROM tDocumentExceptions WHERE CompanyID=6);

Yet when I run this I get the following error:
ERROR 1064: You have an error in your SQL syntax near 'SELECT DocumentID FROM tDocumentExceptions WHERE CompanyID=6)' at line 1

Any ideas?

Kevin

 

[Coderifous]

Is that a subselect? I thought MySQL didn't support subselects.

--jim

 

[Niv3k]

Well, that's annoying, but apparently true... darn.

Thanks!