All,
I have successfully implemented code relying on the doSelectJoinXX() methods auto-generated by Torque (supporting foreign keys). However, in my scenario, I have 4 tables, table One with tables Two, Three and Four each have foreign keys pointing to table One. I have (spent much time) reviewing the doSelectJoinTwo(), doSelectJoinThree() and doSelectJoinFour() auto-generated in BaseOnePeer but have not been able figure out how to call or merge these methods so as to join all four tables to yeild a single result set from which I can retrieve individual columns from each of the four tables. (I would like to pass the results to a Velocity #foreach). Isn't there a way to accomplish the following using Criteria and the doSelectJoin methods: (?????) SELECT One.name, Two.type, Three.cat, Four.color FROM One, OUTER Two, OUTER Three, OUTER Four WHERE One.id = 1234 AND One.id = Two.id AND One.id = Three.id AND One.id = Four.id Thanks to anyone who contributes to my enlightenment !!!!! Jeff Gehrung (Sr. Programmer Analyst) Holstein Association USA Brattleboro VT 05302 802.451.4146 [EMAIL PROTECTED] [EMAIL PROTECTED] I'm told "42" answers most ?s. --------------------------------- Do you Yahoo!? New DSL Internet Access from SBC & Yahoo!
