Hi all,
can I rewrite to "Hibernate Criteria" this SQL?

SELECT u.id, p.num
FROM user AS u
LEFT JOIN (SELECT SUM(p.num) AS num, p.id FROM user_num AS p WHERE p.obd = '200802' GROUP BY p.id) AS p ON p.id = u.id
WHERE .....

I have Hibernate 3.2.3 and MySQL 5.0.

I know basic things with criteria as Subquery.xxx, but this feature is only for "criteria data (as exist, in, ....)".
Can I join table as subquery in Hibernate Criteria?

Thanks!