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)