ALTER view [dbo].[Inventorymgmt] AS SELECT distinct T0.ItemName,T0.Qty,T1.Qty as ' usedqty' FROM [dbo].[MaterialIO] as T0 INNER JOIN [dbo].[MaterialOutuse] as T1 on T0.itemname=t1.itemname group by T0.Qty,t1.Qty,T0.ItemName
ItemName Qty usedqty ACID 10 0 ACID 10 5 ACID 20 0 ACID 20 5 BRASS 50 20
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)