On Friday, September 10, 2010 11:36:59 am Nate Lowrie wrote: > 2010/9/10 Jacek Kałucki <[email protected]>: > > Użytkownik Nate Lowrie napisał: > >> Suppose I have a billing_address_id and a shipping_address_id in an > >> orders table. I want to pull both addresses in via joins on the > >> bizobj, but the addJoin field doesn't have an option for an alias. > >> Any suggestions? > > > > Just use "alias1.key = alias2.fkey". > > So I can do the following and it will automatically recognize the alias? > > self.addJoin("addresses", > "orders.shipping_address_id=shipping_address.id", joinType='inner') > self.addJoin("addresses", > "orders.billing_address_id=billing_address.id", joinType='inner') > > I just tried it and it's not working for me. > > Nate
show us the bizobj.CurrentSQL/UserSQL and maybe we can see the problem. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
