How to do Minus HQL

Question

I have a table A{id, foo, ...} and a table B{id, boo, idA} I want All objects in A that the ids doesn't appear in B

in Oracle SQL would looks like:

SELECT id FROM A MINUS( SELECT idA FROM B);

Answer 1

MINUS function not exists in HQL, go here on paragraph 14.10 Expressions.

Try this:

SELECT id FROM A
WHERE NOT EXISTS
    (SELECT 'X' FROM B WHERE B.idA = A.id)

Answer 2

Is easier than I supposed, I was focused in the minus

select a.id from A as a where a.id not in (select idA from B)

thanks