Hi Tom,
I think you need to specify the join between the two tables in the query,
otherwise you get the full product of the two tables. Please check the Web2py
book at
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Inner-joins
Please show the model files if you
Hi,
I have been using SQLFORM.grid to display some legacy Oracle tables. While
it works fine when the query is for a single table, as soon as the query
involves a join between two tables the grid returns multiple duplicate
entries. (I'm using web2py 2.13.4-)
The result looks like this:
2 matches
Mail list logo