whhoooo who – SQL UPDATE A PORTION OF FIELD FROM FIELD IN OTHER FILE

UPDATE prddtalib/crtran Set CROBATCH   =  (SELECT
substr(client_ID,4,2) FROM ritadb30/request where crtran.crritaid =
request.troutd) concat substr(crobatch,3,10)
WHERE crtran.crritaid IN (Select troutd FROM
ritadb30/request)
50 rows updated in CRTRAN in PRDDTALIB.

11:55 pm still got it