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
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
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.