[hql] Forum Topics

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; …

hi I am working on HQL queries and writing an application in Java it is just in development phase so I am using a dummy database. But I am having troubles with displaying result using HQL queries. /** * Displays a report listing all companies that have no departments. */ …