Update error...!

UPDATE paywork
SET ot1_hrs = 0,

	 ot1_amount = 0,
	 ot2_hrs = 0,
	ot2_amount= 0,
	 ot3_hrs= 0,
FROM paywork,
	  emp_master
WHERE ( paywork.emp_code = emp_master.emp_code ) AND
	   ( emp_master.loc_cd like :is_loc_cd  ) ;

this code is giving me error..

Whether i can use "From" in an update query? cos SQL plus is giving an error message on that,

if i'm not using the from i cant check the condition on where clause.

Can any one tell me what i can do for this Received on Mon Nov 19 2007 - 04:10:32 CST