DROP VIEW LD0VAA0ActivityAttendance
;

CREATE VIEW LD0VAA0ActivityAttendance
AS 
SELECT
 U80.*
,Q.KLARTEXT AS FRANVAROORSAK_T

FROM LD0V0U80 AS U80 
LEFT OUTER JOIN LD0V0Q01 AS Q ON Q.KODTYP = 'LNFRANVORS' AND U80.FRANVAROORSAK = Q.KOD
;