HQL Query question

jpratt · **Posted:** Tue Jul 06, 2004 11:16 am

Hello,
I am having a problem trying to figure out how to query two different tables. Both tables have a series of documents, one table (A) has been published for a users to view, the other one (B) hasn't.

My question is how do I find the documents from table A that are not in table B. I believe it is something like this, but it isn't working.

Code:

mySession.find("select doc from DOCUMENT_A docA, DOCUMENT_B docB where docA != docB");

Any help would be great!

---Jason

emmanuel · **Posted:** Tue Jul 06, 2004 11:55 am

Read the reference guide and any basic tutorial