Re: [castor-dev] RE: jdo,how to support the multi- table query?

[tanhr]

Title: Message

sure i think so but it is trouble why not consider the sql string of multi table query?? it is strange and where is the advantage  of JDO  comparing to JDBC?   -----Original Message----- From: casperhuadoc [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] RE: jdo,how to support the multi- table query? An Multi-table query could be seprate to multi single-table query, is it right? Could you solve the problem this way .   ----- Original Message ----- From: tanhr To: [EMAIL PROTECTED] Sent: Friday, January 25, 2002 10:12 AM Subject: Re: [castor-dev] RE: jdo,how to support the multi- table query?          Thomas              thank u for ur reply              but why not make the SQL-String in JDO abide the latest SQL standard,though the Object stands for  the Data?              why does JDO let us study a new SQL-String Structure?              i am sorry to hear the message from u              we must use multi-table query,maybe 2,3,4,5...and time up,so i come here to look for the answer,beg ur pardon           -----Original Message----- From: Thomas Yip [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:49 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] RE: jdo,how to support the multi- table query? Hi Tanhr,   Please take a look at the FAQ first, which is on our website. http://castor.exolab.org/jdo-faq.html#OQL      I cannot get Castor OQL to join two objects for me.      Is it supported?   Nested OQL query is not support.   The fastest way to get an answer for a common question is to read the document on the web site, the javadoc and search the mail archive, and the test cases. If you still need help after finish reading all of them, free feel to ask question on the mailing list. But, please be very patient when you are asking question on the mailing list. You are asking people to help you, so it is reasonable to give developers and users some times, and let them answer your question in the time which is convenience to them.   Also, providing as much background as possible. For example, how you are using Castor; what workaround did you try; what assumption you’ve made; what unexpected result did you got, which document is unclear etc. All those information would help other who try to help you.         Thomas     -----Original Message----- >From: tanhr [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 24, 2002 4:59 AM >To: [EMAIL PROTECTED] >Subject: [castor-dev] RE: jdo,how to support the multi- table query? > >ladies and gentlemen: >         SOS! >          help me please ! >          >          example:   >             select i from scheduler i where i.userID   >in(select p.getUserID from participator p where p.userName="john")  >  >it is correct ?????????? >i wanna get the answer,thank u :)  >  >  >who can give a example of multi-table query  >thank u ! >  >  >