Update SQL

[warrenk]

Need to create an update SQL and am not sure how to do this...

I want to update the sent_item = '2' if the following condition below is true...

SELECT * FROM TB_RTLINVHDR a, TB_RTLINVDET b where
invoice = invoice_number and
a.tran_date = b.tran_date and
a.store_number = b.store_number and
ss_ind = 'Y' and sent_item = '0'

Thanks for any help!
Warren

 

[guelphdad]

Try this (untested)

UPDATE TB_RTLINVHDR a, TB_RTLINVDET b
SET 
  sent_item = 2
WHERE
  invoice = invoice_number 
AND
  a.tran_date = b.tran_date 
AND
  a.store_number = b.store_number 
AND
  ss_ind = 'Y' 
AND
  sent_item = 0