Hi All, I have a search results screen where data is pulled from two different tables, the second one however is linked via two other tables, so I need to select across four tables in all. What is the most elegant way to do this using Torque?
Lets call them Table1, Table2, Table3 and Table4. Table2 has FKs pointing to Table1 and Table3; Table3 has a FK pointing to Table4. I need to display data from Table1 and one column from Table4 in the jsp. It seems like it would be easiest to do multiple selects and return two different result Lists to the jsp, and loop thru them in parallel. Is there a better way? I am new to Torque and would really appreciate some help! Thanks, Arinaya --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
