CREATE VIEW [dbo].[FirstMSGDate_View] AS
SELECT
  MSG.LOGICALREF,
  SPT.USERID,
  SPT.ORDERDATE,
  MSG.CREATE_DATE
FROM IHR.dbo.MALZEME_SIPARIS_GECMISI_TUMU AS MSG
INNER JOIN UNIVERSALDB.dbo.STOK_RAPOR_SEPET_TEKIL_SIPARISLAR AS SPT ON MSG.ITEMREF = SPT.STOCKREF