Allow sub-queries to be performed within the DAL. How? This would be a good example.
db(db.table.field1==db.tbl2.field2).select(db.tbl2.ALL, db (db.hola.id==db.massimo.the_id)._select(db.hola.ALL)) The db() within a .select() should perform a subquery when selecting like that. The system currently does the correct SQL code *EXCEPT* adding parenthesis around the actual query. The only problem with this, is that I don't know if it's SQL standard. I believe it is, but can someone back this up? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
