On Sun, Jul 30, 2006 at 04:32:42PM -0300, maram wrote:
> "SELECT Lectura.periodo, Lectura.consumo, Usuario.ruta, Usuario.nombre
Lectura.select() can only select columns from Lectura table. If you want
columns from different tables you would want to use sqlbuilder.Select(),
but it cannot do JOINs.
So your options are:
1. Use a different SELECT that only selects rows from Lectura (but uses a
JOIN).
2. Patch Select() to support JOINs.
3. Run the query verbatim via connection.queryAll().
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
