DROP VIEW LD0VJI40
;
CREATE VIEW LD0VJI40 
AS SELECT 
I40.SOKGRUPPNR,
I40.GENERELL,
I40.BENAMNING,
I40.IDM_ID,
I40.UPDDAT,
I40.UPDSIGN,
I50.ANVID
from LD0P0I40 I40 
join LD0P0I50 I50 
on I40.SOKGRUPPNR = I50.SOKGRUPPNR
;