How to implement join without association in criteria.

kondapelly · **Joined:** Wed Dec 03, 2008 8:05 am **Posts:** 11

Hi All,

I have an issue with Criteria.

I have two tables without association. My query is as follows,

SELECT * FROM TRACE_USER TU, AUDIT_EVENT_LOG AL WHERE TU_USER_ID = AL.ACTIVITY_USER

ORDER BY AL.CHECKOUT,AL.ACTIVITY_USER ASC.

Please help how to implement in Criteria.

Thx in advance.

mmerder · **Posted:** Wed Feb 04, 2009 3:37 am

Hi,
As far as I know, it is not possible to relate these to tables with criteria if you don't have an association mapped between them.