Hello guys Please I have this script VTable and AccTable are on separate database. Please anyone help with a sample workflow to execute this query in the studio
update VTable
set ACCOUNT_NUMBER = (select Distinct ACCOUNT_NUMBER from AccTable where VTable.FULL_PAN = AccTable.PAN)
Best Regards