DROP VIEW LD0VAA0LabourMarketService
;

CREATE VIEW LD0VAA0LabourMarketService AS
	SELECT A45.LNR, A45.PERSONNR, A45.FROMDAT, A45.TOMDAT, A45.ABMINSTYP, A45.UPDDAT, A45.UPDSIGN, Q01.KLARTEXT 
	FROM LD0V0A45 A45 
	LEFT OUTER JOIN LD0V0Q01 AS Q01
 	ON A45.ABMINSTYP = Q01.KOD AND
	Q01.KODTYP = 'ABMINSTYP'
;	