On Tue, Apr 24, 2007 at 06:55:13PM +0200, Diez B. Roggisch wrote:
> Adding two LEFTJOINOns makes C appear twice,
> as the resulting query looks like this:
>
> select ... from P left join C on P.id == C.parent_id, C left join G on C.id
> ==
> G.parent_id where ....
Hint: the first paramter to a JOIN can be None.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
