Member Avatar for _aGt_
_aGt_ 0 Newbie Poster

hello,im new to hibernate and not so familiar to its query language yet. can anyone please help me to translate this mysql query to its hql counterpart.

select TRANSACTION_RECORD.BOOK_TYPE,TRANSACTION_RECORD.ID, TRANSACTION_RECORD.RECORD_DATE,
TRANSACTION_ACCOUNTS.ACCOUNT_NAME, TRANSACTION_ACCOUNTS.DEBIT_AMOUNT, TRANSACTION_ACCOUNTS.CREDIT_AMOUNT, TRANSACTION_ACCOUNTS.ACCOUNT_TYPE
from TRANSACTION_ACCOUNTS
inner join (TRANSACTION_RECORD inner join TRANSACTION_ENTRIES on TRANSACTION_RECORD.ID = TRANSACTION_ENTRIES.TRANS_ID)
on TRANSACTION_ACCOUNTS.ID = TRANSACTION_ENTRIES.TRANSACOUNT_ID;

any form of help will be much appreciated. thanks.

  • 1 Contributor
  • 0 Replies
  • 124 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.