Re: Inserting data into one table from multiple tables
Originally posted by sln81
Iíve a requirement as follows.
The data from 14 tables needs to be dumped into one table
While inserting the data, the columnsí values are to be calculated based on calculations
The calculations involve different columns from different tables.
The number of rows in the each of the 14 tables could be around 50000
Please suggest the best way to do this data transfer from 14 tables to one table.
Thanks in advance.
CREATE TABLE blah AS
this space intentionally left blank