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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Thu, 10 October 2013 20:51

brad Mising name

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.

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 08:09:36 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter