Setting addOrderByAscending() with foreign attribute

[yoon]

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]