My sql code looks as follows

select e.id from entry e, groups_belong_to_group_member g where e.id=g.groups_belong_to_id and
group_entry='Yes' and
name like '%(Countries)%';

"groups_belong_to_group_member g" stores the value of e.id that is linked to a entry.
Therefore you could use the following code as well:


select e.id from entry e where
group_entry='Yes' and
name like '%(Countries)%' and e.id in (select e.id from entry e);

so "groups_belong_to_group_member g" is just a place to store the enry id on that specific entry.


I have tried to convert this to HQL but only get this far

sb.append("select entry from com.workpool.directory.Entry entry where ");
sb.append("entry.groupEntry=\"Yes\" and ");
sb.append("entry.name like '%(Countries)%'");

I still need to complete the rest of my code but can't use asub quiery as mysql cersion does not support it.

Is there some sort of join that can be done to get an object on a object

any help will be appreciated thanks

you can use that first sql query you already have written. make it a named sql query in hibernate and it'll work just fine.

there are many good examples of sql named queries in the source test code that came with the hibernate download, if you just run a text search for sql-query on the hibernate/test folder.

also, session.createSqlQuery() works.