looking to updaqte values on one table to a fixed value if the criteria from another table is true. As an example
I want to update the fcoemplocsting.soc_Costgrp to xxx
if the value in another table is true, selection below as an example.
Within the fcoemposting table can have multiple records with same emp_code but on the Taem table only ever one taem1_employee_employee. So in essence a Many to one.
FROM mtmsadm.fcoempcosting fcoempcosting, mtmsadm.taem_data taem_data
WHERE fcoempcosting.emp_code = taem_data.taem1_employee AND ((taem_data.taemcostcentre='59084'))
How do i modify the update statement to include the from table?