DROP VIEW LD0VAA0ActivityLabourMarket
;

CREATE VIEW LD0VAA0ActivityLabourMarket
AS 
SELECT
 U35.*,
 Q1.KLARTEXT AS STATUS_T,
 U60.BENAMNING AS PRAKPROJ_T
FROM LD0V0U35 AS U35
LEFT OUTER JOIN LD0V0Q01 AS Q1 ON Q1.KODTYP = 'LNSTATUS' AND U35.STATUS = Q1.KOD
LEFT OUTER JOIN LD0V0U60 AS U60 ON U35.PRAKPROJNR = U60.PRAKPROJNR
;