All Forums Database
Nani27 3 posts Joined 10/12
07 May 2013
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

KS42982 137 posts Joined 12/12
08 May 2013

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.

You must sign in to leave a comment.