DROP VIEW LD0VAA0PERSONHISTORY
;
CREATE VIEW LD0VAA0PERSONHISTORY
AS
SELECT PNR
      ,A01.COLNAME
      ,OLDVALUE
      ,NEWVALUE
      ,UPDDAT
      ,UPDSIGN
      ,DATASOURCE
      ,OLDVALUE1
      ,UPDDAT1
      ,UPDSIGN1
      ,OLDVALUE2
      ,UPDDAT2
      ,UPDSIGN2 
	  ,ORDNING  
FROM LD0V0A01 A01
INNER JOIN LD0V0A03 A03 
ON A03.COLNAME = A01.COLNAME
;