How to do Minus HQL

Viewed 6719

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);
2 Answers
Related