Going crazy.. can't join on this compound key class and not sure why?
posted 7 years ago
I have a compound Primary Key and I created an object to represent that Primary Key. What I'm curious about is how I can join on a member property of that primary key object if I so desire.
For example this named query is not working:
select ap from AssociatePreference ap, Associate ass where ass.associateID = ap.pk.associateID and ass.dmzID = :dmzID
I'm not sure why I can't query on that kind of join, there should be a way since it's so darn simple in sql. I understand I can actually get the AssociatePreference List by going after the Associate record - that'll work fine - however there 'should' be a way I can just get AssociatePreferene objects trying a join in some way without caring about the entire Associate.
I've posted relevant portions of code below:
edited bc forgot to disable smilies [ October 27, 2008: Message edited by: Brick Riccardi ]