Updating Table

gregalb · May 31st, 2007, 03:32 PM

Hi all

I am wanting to write an update query that does the following:

Col_A Col_B Col_C Col_D Col_E
58573 4703258 HO 58575 CROSS LEASE
58574 4703258 HO 58575 CROSS LEASE
58575 4703258 SU CRS

I need to update Col_D with Col_A. So where Col_C = HO and Col_E = CROSS LEASE Col_D needs to be updated with Col_A. In this case Col_D needs to have 58575 where Col_C = HO

Can anyone help please?

Thanks

Greg

Jeff Moden · June 2nd, 2007, 04:39 PM

It's just a simple update with a WHERE clause... your description is very nearly the correct code...

Code:

 UPDATE yourtable
    SET Col_D = Col_A
  WHERE Col_C = 'HO'
    AND Col_E = 'CROSS LEASE'

--Jeff Moden