hello my friends i write a script like this :
select v.itemTitle,v.ItemCode ,
(select SUM (Quantity) from INV.vwInventoryReceiptItem) - (select SUM(quantity) from INV.vwInventoryDeliveryItem )from inv.vwInventoryReceiptItem vinner join INV.vwInventoryDeliveryItem k on k.ItemRef=v.Itemref
group by v.itemTitle,v.ItemCode
my problem is that it have result jus only i have data in both tables but when i dont have any data in table INV.vwInventoryDeliveryItem it havent any result
i need that when we have no data in table ' INV.vwInventoryDeliveryItem ' result only sum first table