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:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
