Hi web2py users! 1. Can anyone tell me if the query input field on SQLform smartgrid forms can do a join on 2 or more tables? 2. If so, how do I construct such a query? My attempts my failed and can't find docs on this either...
Note - I would like users to be able to construct and type in their own queries directly in the smartgrid query field. As these queries will be dynamic, doing this programmatically will be difficult - if the query can handle joins or fields from multiple tables then this should be "pie" :) Thanks!
