DROP VIEW LD0VAA0TEAMMEMBERDETAILS
;
CREATE VIEW LD0VAA0TEAMMEMBERDETAILS 
AS 
SELECT TM.ID, 
TM.CASEWORKERID, 
TM.TEAMID, 
I.NAMN  
FROM LD0VAA0TEAMMEMBERS TM
LEFT OUTER JOIN LD0V0I I 
ON TM.CASEWORKERID = I.HAND
;