CODEWITHSUNDEEP
jpajpql
Jeremy S.
Jeremy S.

Reputation: 6623

How to have multiple conditions in JPQL join

I want to join two tables using JPQL:

SELECT * FROM A LEFT JOIN 
B ON A.ID = B.A_ID AND B.lng = 'en'

The important part is AND B.lng = 'en'

Is this possible in JPQL?

Upvotes: 10

Views: 28461

Answers (2)

James
James

Reputation: 18379

JPA 2.0 does not support an ON clause, but the JPA 2.1 draft does.

EclipseLink 2.4 supports an ON clause.

See, http://wiki.eclipse.org/EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying/JPQL#ON

Upvotes: 9

John Kane
John Kane

Reputation: 4443

Yes it is possible, there is a similar question here. However, if your entities are mapped, you should be able to access them in a query.

Upvotes: 1

Related Questions