How to RIGHT JOIN in torque?

[Hamza Rana <Ha...@esstec.com.pk>]

Hi every one
if i have a query like

Select * from  TABLE1 right join TABLE2 on TABLE1.ID=TABLE2.ID

how do i translate it in Torque framework. This query is in MySql and it
return all record of TABLE1 joined with TABLE2 and if there exist same
ID on both TABLE1 and TABLE2 then TABLE2 instance is get, otherwise NULL
is get for TABLE2 instance. 

i can simulate this by getting List of TABLE2 matching instances 1 by 1
with calling TABLE1 object method getTABLE2( ) but this higly
inefficient procedure. Please tell me if there is any way out. 

regards
Hamza Rana


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>