select entry from com.workpool.directory.Entry entry inner join entry.memberOf as member where entry.groupEntry=\"Yes\" and
entry.name like '%(Countries)%' and view.entry.id = entry.id.



the above query returns a result set is it possible to be able to create some sort of query in HQL on that result set comparring row by row the value from this set to another value from another table.

I did notice that their is a "fetch" command, but I am not sure hows this works or if it is the correct command could somebody please help or give any further info.

Thank you


ryan