Thread: [SQLObject] Joining Multiple Tables
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Randall S. <ra...@tn...> - 2005-09-02 21:46:02
|
With this setup, Class A -> b_things(SQLMultipleJoin) -> Class B -> c_thing(SingleJoin) -> Class C I'm trying to accomplish this. Select B.* FROM A INNER JOIN B ON A.id = B.A_id INNER JOIN C ON b.id = c.B_id I have an instance of A. My guess would be something like this: B_Results = A.b_things.filter(B.q.c_thing != None) One problem is that c_thing is not accessible under B.q because it is a SingleJoin property. I'm trying to avoid doing manual sql. Any help or advice would be appreciated. Randall |
From: Oleg B. <ph...@ma...> - 2005-09-03 08:43:34
|
On Fri, Sep 02, 2005 at 04:45:28PM -0500, Randall Smith wrote: > I'm trying to accomplish this. > > Select B.* FROM > A INNER JOIN B ON A.id = B.A_id > INNER JOIN C ON b.id = c.B_id from sqlobject.sqlbuilder import INNERJOINOn Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |