Hi,

I am trying to find out if it is possible to convert the following sql query into a Criteria query? The query is as follows:

SELECT *
FROM AUDCOPYUSERS A JOIN LOGIN_AUDIT B ON A.USERS_SAN=B.USERS_SAN
LEFT OUTER JOIN LOGIN_SESSION C ON B.LOGINAUDIT_SAN=C.LOGINAUDIT_SAN
LEFT OUTER JOIN ACTION E ON C.LOGINSESSION_SAN=E.LOGINSESSION_SAN
LEFT OUTER JOIN ACTION_TYPE F ON E.ACTIONTYPE_SAN=F.ACTIONTYPE_SAN
JOIN USERS_AUDIT G ON E.ACTION_SAN=G.ACTION_SAN
WHERE A.USRNUMBER='NOHITS'
ORDER BY B.LOGTIME,E.ACTION_TIME

Any help is appreciated.

Thanks.