Should the query look like this?
SELECT FROM book, author a1, author a2 WHERE
book.author_id = a1.id AND
book.second_author_id = a2.id
Pls correct me if I am wrong.
I think you can achieve this with Criterion??? But hell, I am not shure...
don't have much of experience with Torque... wait for somebody qualified to
really answer you this question.
Cheers,
Alex
> select from BOOK,AUTHOR,BOOK B where
> BOOK.AUTHOR_ID=AUTHOR.AUTHOR_ID AND
> B.SECOND_AUTHOR_ID=AUTHOR.AUTHOR_ID
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org