SELECT InventoryCode,InventoryName Product, isnull(Price,0) Price
FROM Erp_Inventory
left join Erp_InventoryPriceList on Erp_InventoryPriceList.InventoryId = Erp_Inventory.RecId
FOR XML PATH('MALZEMELER'), ROOT('BILGILER')
FROM Erp_Inventory
left join Erp_InventoryPriceList on Erp_InventoryPriceList.InventoryId = Erp_Inventory.RecId
FOR XML PATH('MALZEMELER'), ROOT('BILGILER')