Advertisement
Guest User

Untitled

a guest
Jan 28th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE (
  2.   SELECT
  3.     CEH_RAPORT.SDDAY AS NEW_SDDAY,
  4.     CEH1_DELOFPRODUCT.SDDAY AS OLD_SDDAY,
  5.     CEH1_DELOFPRODUCT.DDATE AS DDATE,
  6.   FROM ASUP01.CEH1_RAPORT
  7.     INNER JOIN ASUP01.CEH1_DELOFPRODUCT ON
  8.       CEH1_RAPORT.NAME=CEH1_DELOFPRODUCT.NNAME
  9. ) UP
  10. SET UP.NEW_SDDAY=UP.OLD_SDDAY
  11. WHERE UP.DDATE='18.01.19'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement