How can I construct a criteria query (or even HQL) with a restriction like the
following?
select *
from item
inner join program on program.unique_id = item.program_id
where item.name + ' (' + program.name + ')' like ?
I would like to use Restrictions.sqlRestriction() for the where clause, but I
can't figure out how to get the correct SQL alias for the "program" entity.
Thanks,
________________________________
RUSSELL E. MORRISEY
Programmer Analyst Professional
Mission Solutions Engineering, LLC
| [email protected] | www.missionse.com<http://www.missionse.com/>
304 West Route 38, Moorestown, NJ 08057-3212
________________________________
This is a PRIVATE message. If you are not the intended recipient, please delete
without copying and kindly advise us by e-mail of the mistake in delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind MSE to any
order or other contract unless pursuant to explicit written agreement or
government initiative expressly permitting the use of e-mail for such purpose.
