On Wed, Apr 19, 2006 at 01:10:36AM +0100, [EMAIL PROTECTED] wrote:
> I've been through the documentation and all the examples of JOINS just
> have results from a single table.
JOINs can use as many tables as you want. Examples:
Stright join:
Table1.select(AND(Table1.q.id==Table2.q.t1_id, Table2.q.name=="value"))
LEFT JOIN:
Table1.select(join=LEFTJOIN(Table2, Table3))
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 xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
