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@...
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
_______________________________________________
eclipselink-users mailing list
eclipselink-users@...
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
