Hi

I have encounter problem in mysql with my query regarding subquery support. The IN and NOT IN are not supported.
my client's server is running the old version of mysql and he cant upgrade because of some reasons.

I read that you can convert this so it can run it in the old version

The query is below
[code=mysql]
SELECT DISTINCT Document.DocID
FROM Document
Left Join...