Yes, just call c.addJoin twice. E.g. c.addJoin(ImagesPeer.IMAGE_ID, ItemsPeer.SMALL_IMAGE_ID); c.addJoin(ImagesPeer.IMAGE_ID, ItemsPeer.LARGE_ITEM_ID);
- Stephen > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 4:25 PM > To: [EMAIL PROTECTED] > Subject: Using OR for multiple joins > > Hello, > I'm trying to do an OR with two joins and cant figure out how to do it > using torque > My original query is > > select distinct items.item_id,items.small_image_id,items.large_image_id > from items,images where images.image_id=items.small_image_id and > images.image_id=items.large_image_id > > basically the items table has small_image_id and large_image_id both as FK > to images table > > Using Criteria is it possible to add two joins using an OR ? > > thanks > TS > > > > > -- > To unsubscribe, e-mail: <mailto:turbine-torque-user- > [EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:turbine-torque-user- > [EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
