Hi,
I have problem using the following EJB3 query with two sub-query in place.


SELECT t FROM FacilityStatus model, IN(model.facility) t
WHERE t.facilityId IN (SELECT b.facilityId FROM (SELECT t2.facilityId, MAX(model.id.statusAsgnDate
FROM FacilityStatus model1, IN(model1.facility) t2
WHERE model1.statusCodes.statusCode IN (300, 301)
GROUP BY t2.facilityId) b)

When I run the regular SQL on Oracle, it is fine and acceptable.

Can someone please help? Thank you.