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 16:51
brad Mising name is currently offline 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

Previous Topic:Hung threads
Next Topic:Tutorial ?
Goto Forum:
  


Current Time: Sat Aug 23 15:32:36 EDT 2014

Powered by FUDForum. Page generated in 0.01600 seconds