Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE rptledgerfaas
- SET
- toyear='2018',
- toqtr='4'
- WHERE toyear ='0'
- AND fromyear < 2018
- AND rptledgerid
- IN
- (SELECT* FROM(SELECT rptledgerid FROM rptledgerfaas WHERE fromyear='2019')current) ORDER BY fromyear DESC;
Advertisement
Add Comment
Please, Sign In to add comment
