cannot find column
-
Hi I am trying to execute this query but its giving me an error "Cannot find either column "D" or the user-defined function or aggregate "D.bonus", or the name is ambiguous. " Query: MERGE INTO bonuses D USING bonuses1 E ON D.employee_id = S.employee_id) WHEN MATCHED THEN UPDATE SET D.bonus = E.bonus WHEN NOT MATCHED THEN INSERT (D.employee_id, D.bonus) VALUES ES.employee_id, E.salary*0.1) WHERE (E.salary <= 8000); UPDATE bonuses Set bonus=10000 FROM bonuses D JOIN cbonuses1 E ON D.employee_id = S.employee_id) Any idea??
-
Hi I am trying to execute this query but its giving me an error "Cannot find either column "D" or the user-defined function or aggregate "D.bonus", or the name is ambiguous. " Query: MERGE INTO bonuses D USING bonuses1 E ON D.employee_id = S.employee_id) WHEN MATCHED THEN UPDATE SET D.bonus = E.bonus WHEN NOT MATCHED THEN INSERT (D.employee_id, D.bonus) VALUES ES.employee_id, E.salary*0.1) WHERE (E.salary <= 8000); UPDATE bonuses Set bonus=10000 FROM bonuses D JOIN cbonuses1 E ON D.employee_id = S.employee_id) Any idea??