Oleg Broytmann wrote:
On Fri, Aug 03, 2007 at 10:55:06AM -0500, Jim Steil wrote:
  
Thanks for the response.  I do understand all of that, but in the doc 
(http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it 
gives the following example:

MyTable.select(
   join=LEFTJOINOn(None, Table1,
                   MyTable.q.name == Table1.q.value))

will return the following sql statement

SELECT * FROM my_table
LEFT JOIN table2 ON my_table.name = table1.value;

I assumed the * was meant as all columns.
    

   No, it only means "all columns from MyTable". This has to be mentioned
in the docs.
   The only way in SQLObject to select columns from multiple tables is
sqlbuilder.Select().

Oleg.
  

I've tried that in the past, but I seem to recall that it doesn't return the same type of object as a regular .select(), and that is what is needed for the PaginateDataGrid in TG.  Someone, please correct me if I'm wrong, I don't claim absolute knowledge of the tools.

    -Jim