Reputation: 1952
I have 3 table: Messages, MessageTypes, MessageReceivers (MSSQL)
This is my code: query = session.createQuery("from Messages as m left join m.messageReceivers as mr join m.messageTypes as mt " + "where mt.typeName = 'Assignment' " + "and mr.accounts.accId =:id"); query.setParameter("id", recID); return query.list();
It return an Object[] (call it O), each element of O is a composition of one Messages- one MEssageReceiver-oneMessagesType
Now i want to get only an List of Messages from that three tables, how can I do it?
Upvotes: 0
Views: 653
Reputation: 5439
Add select m
to your query.
query = session.createQuery("select m from Messages as m left join ...");
Upvotes: 1