Hello,
In MS Query when I run the following:
Create view tal_contractor_rsrc as
SELECT d.PROJ_ID, d.PROJ_SHORT_NAME, c.TASK_CODE, c.TASK_NAME, c.TASK_TYPE, c.PHYS_COMPLETE_PCT, c.TARGET_DRTN_HR_CNT, c.REMAIN_DRTN_HR_CNT, c.ACT_START_DATE, c.ACT_END_DATE, c.EARLY_START_DATE, c.EARLY_END_DATE, a.RSRC_SHORT_NAME, a.RSRC_NAME, Sum(b.ACT_REG_COST) as T_Act_Reg_Cost, Sum(b.ACT_THIS_PER_COST) as T_Act_This_Per_Cost, Sum(b.REMAIN_COST) as T_Remain_Cost, Sum(b.TARGET_COST) as T_Target_Cost
FROM rsrc a, taskrsrc b, task c, project d
WHERE a.RSRC_ID = b.RSRC_ID AND b.PROJ_ID = c.PROJ_ID AND b.TASK_ID = c.TASK_ID AND c.PROJ_ID = d.PROJ_ID AND ((b.RSRC_ID=3920))
GROUP BY d.PROJ_ID, d.PROJ_SHORT_NAME, c.TASK_CODE, c.TASK_NAME, c.TASK_TYPE, c.PHYS_COMPLETE_PCT, c.TARGET_DRTN_HR_CNT, c.REMAIN_DRTN_HR_CNT, c.ACT_START_DATE, c.ACT_END_DATE, c.EARLY_START_DATE, c.EARLY_END_DATE, a.RSRC_SHORT_NAME, a.RSRC_NAME
I get the error message ORA-00998: must name this expression with a column alias.
For the life of me I cannot see what column it is that is causing the problem.
Regards,
Tom Leahy
In MS Query when I run the following:
Create view tal_contractor_rsrc as
SELECT d.PROJ_ID, d.PROJ_SHORT_NAME, c.TASK_CODE, c.TASK_NAME, c.TASK_TYPE, c.PHYS_COMPLETE_PCT, c.TARGET_DRTN_HR_CNT, c.REMAIN_DRTN_HR_CNT, c.ACT_START_DATE, c.ACT_END_DATE, c.EARLY_START_DATE, c.EARLY_END_DATE, a.RSRC_SHORT_NAME, a.RSRC_NAME, Sum(b.ACT_REG_COST) as T_Act_Reg_Cost, Sum(b.ACT_THIS_PER_COST) as T_Act_This_Per_Cost, Sum(b.REMAIN_COST) as T_Remain_Cost, Sum(b.TARGET_COST) as T_Target_Cost
FROM rsrc a, taskrsrc b, task c, project d
WHERE a.RSRC_ID = b.RSRC_ID AND b.PROJ_ID = c.PROJ_ID AND b.TASK_ID = c.TASK_ID AND c.PROJ_ID = d.PROJ_ID AND ((b.RSRC_ID=3920))
GROUP BY d.PROJ_ID, d.PROJ_SHORT_NAME, c.TASK_CODE, c.TASK_NAME, c.TASK_TYPE, c.PHYS_COMPLETE_PCT, c.TARGET_DRTN_HR_CNT, c.REMAIN_DRTN_HR_CNT, c.ACT_START_DATE, c.ACT_END_DATE, c.EARLY_START_DATE, c.EARLY_END_DATE, a.RSRC_SHORT_NAME, a.RSRC_NAME
I get the error message ORA-00998: must name this expression with a column alias.
For the life of me I cannot see what column it is that is causing the problem.
Regards,
Tom Leahy