[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[eclipselink-users] How to left join with expression
- From: Andreas König <andreas.koenig@xxxxxxxxxx>
- Date: Wed, 17 Sep 2008 21:20:48 +0200
- Delivered-to: firstname.lastname@example.org
- User-agent: Thunderbird 18.104.22.168 (X11/20080724)
I think, I didn't really get the expression language yet.
I have two classes:
Offer and Publication
An Offer can have multiple publications, from which only the youngest is
interesting for me.
For architectural reasons, the offer-object has no reference to the
publication(s). Only the publication has a refence to the object.
How do I get an SQL like this with expression language?
LEFT OUTER JOIN PUBLICATION pub ON pub.offer_id = offer.id
WHERE NOT EXISTS (not so important subquery)
I tried different ExpressionBuilders, but nothing seemed to work. The
result was always wrong way around: pub left outer join offer.
Thanx in advance!
serie a logistics solutions AG
Hülchrather Straße 15
T +49 221 500 60 7-21
F +49 221 500 56 85
Vorstand: Axel Löhr, Erwin Soldo
Aufsichtsrat: Adam Musialik (Vors.), Fritz Pleitgen, Hans Jörg Klofat
Amtsgericht Köln HRB 61725