Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update t0 set t0.series=t2.series
- from NNM2 t0
- inner join NNM1 t1 on t1.Series=t0.Series
- inner join NNM1 t2 on t2.SeriesName=replace(t1.SeriesName,'19','20') and t1.ObjectCode=t2.objectcode
- --and t0.ObjectCode='13'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement