IF exists(SELECT * FROM sysobjects WHERE name = 'LD0V0FatherhoodInformation')
                        DROP VIEW LD0V0FatherhoodInformation
;

CREATE VIEW LD0V0FatherhoodInformation
AS
SELECT
E55.*, Q01.KLARTEXT FADFORLAND_T,
Q01B.KLARTEXT FADFORMEDBORGARSKAP_T, Q01B.XTXT1 FADFORMEDBORGARSKAP_ISO_T
FROM LD0P0E55 E55 
LEFT JOIN LD0V0Q01 Q01 
ON E55.FADFORLAND = Q01.KOD AND Q01.KODTYP = 'LAND'
LEFT JOIN LD0V0Q01 Q01B 
ON E55.FADFORMEDBORGARSKAP = Q01B.KOD AND Q01B.KODTYP = 'LAND'
;