Hello,
I have a INSERT query which is happening with a SELECT query.
===================================================
INSERT INTO tbl_fact_effort_lvl_data
( ............... )
SELECT ria.report_id
,report_status
:
:
,((SELECT lov_num_val
FROM tbl_reference_data
WHERE lov_type = 'FREQUENCY'
) * (SELECT SUM(pph_task)
FROM tbl_ri_process
WHERE report_id = ria.report_id )) TOT_YEARLY_PROD_HOURS
,TOT_YEARLY_PROD_HOURS * tf.fac_value TOT_FACT_DATA
,location_id
FROM tbl_fact tf
LEFT JOIN ......... ;
====================================================
So, here I want to use column alias TOT_YEARLY_PROD_HOURS as another column to derive another column value TOT_FACT_DATA.
Thanks !!
Aparna