Thanks. michael
> You can add the foreign key definition in the schema. Look at the > element:reference in > http://jakarta.apache.org/turbine/torque/schema-reference.html > > I think it would work just by creating the join in the criteria but if > you add the reference > it will add some methods that would make it easier and it will create > the foreign key definitions > in the .sql that creates the tables. > -- > Humberto > > -----Original Message----- > From: Eigen Technology Pty Ltd [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 20, 2003 1:00 AM > To: [EMAIL PROTECTED] > Subject: Re: Foreign Key > > > Thanks, > >>From what you have suggested, I don't have to add Foreign Keys to these > fields in my sechma file? All is needed is just a join criterial in my > .java file. > > thanks > michael > > > >> Hi Michael, >> >> I'm guessing you're trying to get the data from Table 2. So the >> following would be all that's required (I think): >> >> Criteria criteria = new Criteria(); >> criteria.add(Table1Peer.ID, <your constraint here>); >> criteria.addJoin(Table1Peer.ID, Table2Peer.Col_C); >> criteria.addJoin(Table1Peer.ID, Table2Peer.Col_D); >> >> List result = Table2Peer.doSelect(criteria); >> >> HTH, >> CP >> >> >> Eigen Technology Pty Ltd wrote: >>> Hi... >>> >>> If a table has two columns which are related to another table, can I >>> Join them using Foreign Key, if so, how could I do it? >>> >>> Table 1 >>> ID >>> Col_A >>> Col_B >>> >>> Table 2 >>> ID >>> Col_C <---- need to link to ID in table_1 >>> Col_D <---- also need to link to ID in table_1 >>> >>> thanks >>> michael >>> >>> >>> >>> -- >>> To unsubscribe, e-mail: >>> <mailto:[EMAIL PROTECTED]> For >>> additional commands, e-mail: >>> <mailto:[EMAIL PROTECTED]> >>> >>> >>> >> >> >> -- >> R E D S H E R I F F >> C.P. Lim - Software Engineer >> Level 1, 10 Queens Road +61 3 9864 0733 tel >> Melbourne VIC +61 3 9864 0778 fax >> Australia +61 413 781 846 mob >> >> This message and any files transmitted with it are confidential and >> intended solely for the use of the individual or entity to whom they >> are >> addressed. If you are not the intended recipient, you are hereby >> notified that any use or dissemination of this communication is >> strictly >> prohibited. If you have received this message in error please notify >> us immediately by return email or telephone +61 (3) 9659 0432, then >> delete this message. Any views expressed in this message are those of >> the >> individual sender and many not necessarily reflect the views of Red >> Sheriff. >> >> >> -- >> To unsubscribe, e-mail: >> <mailto:[EMAIL PROTECTED]> For >> additional commands, e-mail: >> <mailto:[EMAIL PROTECTED]> > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> For > additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
