Because I have a controller that presents data for a table. So to present data which is a join of several tables, I would build a table and then use that same controller. Where can I find more information on how to make more complex queries and presenting data with web2py?
On Jan 28, 6:27 pm, DenesL <denes1...@yahoo.ca> wrote: > It can be done, but why do you want to do it?. > > On Jan 28, 10:42 am, vortex <billyara...@gmail.com> wrote: > > > Is it possible to join to tables and create a new table based on this > > join using only DAL? > > > CREATE TABLE newtable AS SELECT ta.key, ta.col1, tb.col2 FROM ta > > JOIN tb.col1 on (ta.key=tb.key) > >