I have 3 tables sales, production and consumption with which i have 20 orders for item b and the other 2 tables have the raw materials to make the item b. The production and consumption table gives the qty for preparing one item b. So i have to calculate qty for 20 such item b. So in the output i need item name and the quantity for each item. so can anyone solve this issue.