Update join query
822979Dec 10 2010 — edited Dec 11 2010Hi,
I am trying to perform an update query that uses a join... the native Oracle sql is
UPDATE (select i.status FROM improvement_supplemental i
INNER JOIN property p ON i.rpd_property_id = p.rpd_property_id
WHERE p.county_cd = '42127') t set t.status = '99';
Can I do the equivalent in JPA? I've tried to google the syntax, but I have been unsucessful. I've tried a few things with em.createQuery, and em.createNativeQuery and cannot avoid syntax errors or GlassFish hangs.
Any help would be greatly appreciated.
Vince