[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[List Home]
[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: eclipselink-users@eclipse.org
- User-agent: Thunderbird 2.0.0.16 (X11/20080724)
Hey there...
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?
SELECT offer.id,
publication.id
FROM
Offer offer
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!
Andreas
--
Andreas König
Developer
andreas.koenig@xxxxxxxxxx
serie a logistics solutions AG
Hülchrather Straße 15
D-50670 Köln
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
www.serie-a.de