Eclipse Community Forums: EclipseLink » Utilizing value in joined table (ExpressionBuilder)

Home » Eclipse Projects » EclipseLink » Utilizing value in joined table (ExpressionBuilder)

Utilizing value in joined table (ExpressionBuilder) [message #1131836]

Thu, 10 October 2013 16:51

Eclipse User

We have an Insurance entity with a one to many relationship to Facility. We are having issues translating the following sql into an Expression.

SELECT *
FROM insurance ins
INNER JOIN facility fac ON
ins.source_facility_key = fac.facility_key
WHERE CURRENT_TIMESTAMP <= ins.plan_expiration_date + (INTERVAL '1 days' * fac.enrollment_expiration_ttl) ;

Thoughts?
Thanks in advance
-Brad

Previous Topic:	JPA: subquery SQL generation bug
Next Topic:	Tutorial ?

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Nov 08 20:23:38 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter