[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] How to left join with expression

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