first you have to have a relationship defined between classes of table a and classes of table b. then you you can use addOrderByAscending("relAtoB.name")
where relAtoB is the name of the relationship.
hth jakob
[EMAIL PROTECTED] wrote:
Hi all,
I'd like to sort the result set based on a field from another table. With SQL it'd be like:
SELECT A.* FROM A, B WHERE A.AID = 10 AND A.BID = B.BID ORDER BY B.NAME;
(A.BID is a foreign key to table B).
How would you achieve the same effect with OJB?
Thanks!
Sincerely, daehyun yoon
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
