Hi I think that what you are trying is an explicit join that is not supported in castor.
You need to put the relationship into your mapping so that User contains an object reference to Person. Then you may use something like WHERE user.persion.name = "gizmo" Tobias > -----Original Message----- > From: Knut Herhold [mailto:knut.herhold@;sourcepark.de] > Sent: Donnerstag, 17. Oktober 2002 13:21 > To: [EMAIL PROTECTED] > Subject: [castor-dev] incorrect token type, why ??? > > > hi, > > when i use this query > > ========================================================== > "SELECT usr FROM com.xxxxxxxx.access.Person prs, > com.xxxxxxxx.access.User usr WHERE prs.id = usr.personId" > ========================================================== > > i get the message > > ===================================================================== > org.exolab.castor.jdo.oql.OQLSyntaxException: An incorrect token type > was found near , (45, need 0 > ===================================================================== > > Is the syntax incorrect > How can i use this query. > > please help me > > Thanks > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
