Hi!

Does subquery's need something special properties?

David says in:

http://forum.hibernate.org/viewtopic.php?t=927245

.. that "HQL will be converted approrpriately to multiple SQLs if subselects are not supported
by the dialect.", but still i get following exception message:

SEVERE: Syntax error or access violation, message from server: "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 ( ripped. )

I use hibernate 2.1.1, mysql-connector-java-3.0.8-stable-bin driver (from www.ibiblio.com/maven/...), and mysql 4.0.18-2 (debian dpkg).

Artsi

I think Mysql supports subqueries starting from version 4.1

Ok. Thank you about information, but i need to get this work with older version.

The sql query, which i need to get work, is something like this:
select * from A where a.key not in ( select key from B where B.key2 != '10')
.. or something like that.. actually i don't know does it work, but that's the idea.

Can i do with those joins?? i don't know much about SQL.

Artsi

Try this
select DISTINCT A.* from A,B where a.key <> B.key OR B.key2 = '10'
I think it will return the same result.