CREATE VIEW LD0V1PERSONDATACHANGELOG AS 
SELECT 
PCL.PNR,
PCL.COLNAME,
PCL.OLDVALUE,
PCL.NEWVALUE,
PCL.UPDDAT,
PCL.UPDSIGN,
PCL.DATASOURCE,
PCL.OLDVALUE1,
PCL.UPDDAT1,
PCL.UPDSIGN1,
PCL.OLDVALUE2,
PCL.UPDDAT2,
PCL.UPDSIGN2,
CASE WHEN PBI.FINNISH IS NULL THEN PCL.COLNAME ELSE PBI.FINNISH + '¤¤' + PCL.COLNAME END AS COLNAME_BILINGUAL
FROM LD0V0A01 PCL
LEFT JOIN LD0V0PERSONBASICINFOTRANSLATIONS PBI ON PCL.COLNAME = PBI.SWEDISH
;