insert into one table from multiple select statements and multiple tables

Database
Fan

insert into one table from multiple select statements and multiple tables

Hi All, I have a table with fields EFF_DT and ASUM_DT and some other. And I need to insert data into this from multiple tables, using sel statements.

Example: Using below sql I need this value to be EFF_DT

SELECT MIN(C2T_EFF_DT) AS EFF_DT

FROM Table1

WHERE DT > END_DT

Using below sql I need this value to AUM_DT

SELECT MIN(C2T_EFF_DT) AS AUM_DT

FROM Table 2

Thank you,

Nani

1 REPLY
Enthusiast

Re: insert into one table from multiple select statements and multiple tables

I am not sure if I got your question here. What is the issue ? I think you want to insert the data into one table from multiple tables, but using one select ? please clarify your question and will try to solve it.