From: Randall Smith <randall@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
I'm trying to avoid doing manual sql. Any help or advice would be
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 Broytmann http://phd.pp.ru/ phd@...
Programmers don't die, they just GOSUB without RETURN.