select p.Id ,BlProdId,[ErpItemId],p.[Price],p.[Stock] , i.Price NewPrice, ISNULL(i.Stock, cast ( 0 as decimal)) NewStock from dbo.blItemsListView i
JOIN dbo.blProducts p ON p.ErpItemId = i.Id
