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