• Post Reply Bookmark Topic Watch Topic
  • New Topic

Going crazy.. can't join on this compound key class and not sure why?  RSS feed

Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

The error:

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 ]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!