ideally as per your table names, this is logicalCREATE VIEW SalesViewASSELECT I.ItemID, I.ItemName, i.Qty AS QtyInStock,COALESCE(s.Qty, 0) AS SalesQty,i.Qty - COALESCE(s.Qty, 0) AS ResidualQtyFROM Inventory I LEFT JOIN Sales s ON I.ItemID = s.ItemId
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs