Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Utilizing value in joined table (ExpressionBuilder)
Utilizing value in joined table (ExpressionBuilder) [message #1131836] Thu, 10 October 2013 20:51
brad Mising name is currently offline brad Mising nameFriend
Messages: 17
Registered: February 2010
Junior Member
We have an Insurance entity with a one to many relationship to Facility. We are having issues translating the following sql into an Expression.

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) ;

Thanks in advance

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

Current Time: Mon May 21 05:32:36 GMT 2018

Powered by FUDForum. Page generated in 0.02071 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top