sql - Update table according to the another table value -
i have 2 tables employees
empid | empname | empdob
and warehouseemployeers
warehouseempid | position | province
i need update employee
table according warehouseemployers
table's values. how update details employee table according warehouse province , position?
i have tried it's not working:
update employee set a.empname = 'steven', a.empdob = '5-5-1990' employee a, warehouseemployee b, a.empid = b.warehouseempid , position = 'manager', province = 'central'
can please me in sql server?
please use script
update set a.empname = 'steven' , a.empdob='5-5-1990' employee inner join warehouseemployee b on a.empid = b.warehouseempid , position = 'manager' , province = 'central'
Comments
Post a Comment