web2py does not allow this. It allows subselect in queries db(db.table.field.belongs(db()_select(db.othertable.otherfield)).select () # ALLOWED
Massimo On Apr 11, 12:08 am, TheDude <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
