CREATE VIEW dbo.GUNLUK_SAYIM_LISTESI
AS
SELECT STK.DATE_, STK.TIME_, ITM.CODE, ITM.[NAME], ITM.SPECODE4, STK.STOCK, STK.COUNTING
  FROM [UNIVERSALDB].[dbo].[STOK_KONTROL] AS STK LEFT OUTER JOIN
  LG_011_ITEMS AS ITM ON ITM.LOGICALREF=STK.ITEMREF