Skip to Content
0
Aug 09, 2007 at 06:57 AM

single Update stmt.. for 2 fields

15 Views

Hi everyone,

I have to update 2 fields in my table zsd47_loc_master. I have used 2 update stmts.. for each field. Is it possible to update the table using single stmt.. ?

UPDATE zsd47_loc_master SET capacity = capacity - 1

WHERE location = wk_location

AND status = 'A'.

UPDATE zsd47_loc_master SET status = 'P' WHERE location = wk_location

AND status = 'A'.

thanks in advance,

regards,

Stanley.