What about table3 in your query?
How is linked to table2?
To see the generated sql you can use
db(query)._select(...)
On Thu, Jul 30, 2015 at 12:50 PM, Ian Ryder wrote:
> Hi, I’m trying to construct a query in web2py which I’m struggling with -
> help appreciated :)
>
>
> Table 1
>
>
You may consider db.executesql(""" YOUR SQL QUERY """)
You may also have a look to the generated query with ._select(...). If you
add an underscore before the .select web2py return a string of the
generated query instead of the results of the query... So you can see what
is the issue and fix your
Hi, I’m trying to construct a query in web2py which I’m struggling with -
help appreciated :)
Table 1
table1.batch_id
Table 2
table2.table1
table2.table3
table2.amount
Table 3
table3.name
Query is roughly:
select table3.name, sum(table2.amount), count(tabl
3 matches
Mail list logo