UPDATE PRA_PROCESS_RECENT P SET
P.system = (SELECT DISTINCT PD.TYPE FROM WMPROCESSDEFINITION PD
WHERE PD.PROCESSKEY = P.PROCESSKEY)
UPDATE PRA_PROCESS_RECENT P SET
P.system = (SELECT DISTINCT PD.TYPE FROM WMPROCESSDEFINITION PD
WHERE PD.PROCESSKEY = P.PROCESSKEY)

UPDATE PRA_PROCESS SET PRA_PROCESS.system = WMPROCESSDEFINITION.TYPE
FROM PRA_PROCESS, WMPROCESSDEFINITION WHERE WMPROCESSDEFINITION.
PROCESSKEY = PRA_PROCESS.PROCESSKEY;
UPDATE PRA_PROCESS_RECENT SET PRA_PROCESS_RECENT.system =
WMPROCESSDEFINITION.TYPE
FROM PRA_PROCESS_RECENT, WMPROCESSDEFINITION WHERE WMPROCESSDEFINITION.
PROCESSKEY = PRA_PROCESS_RECENT.PROCESSKEY;