This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

Brick Riccardi
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 = 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