CREATE VIEW dbo.RETURN_LIST_VIEW
AS
SELECT        DML.CODE, DML.ITEMNAME, DML.STOCK, DML.MARKA, DML.TIP, DML.RAF, DML.BLOK, DML.BCOLOR, DML.REF, DML.DURUM, ISNULL(ITM.ONRETURN, 0) AS ONRETURN, ISNULL(ITM.PRICE, '0') AS PRICE, 
                         ITM.REF AS LOGREF, ITM.RETURNREF, ISNULL(ITM.DESCRIPTION_, '') AS DESCRIPTION_, ISNULL(ITM.RETURN_TYPE, '') AS RETURN_TYPE, ITM.TYPE_, RF.FICHENO, RF.DATE_, ITM.BCOLOR AS BRENK, 
                         RF.CLIENTREF
FROM            dbo.RETURN_ITEMS AS ITM LEFT OUTER JOIN
                         dbo.RETURN_FORM AS RF ON RF.REF = ITM.RETURNREF LEFT OUTER JOIN
                         dbo.DEPO_MALZEME_LISTESI_IADE AS DML ON ITM.ITEMREF = DML.REF