Hi sir Use this one Select nameseller,sum(buys) as buys,sum(sells) as sells from( select Seller.NameSeller, sum(buyfromseller.qty*buyfromseller.cost) as buys, 0.0 as sells from Seller left join buyfromseller on buyfromseller.fkseller=seller.idseller group by seller.nameseller Union all select Seller.NameSeller, 0.0 as buys, sum(sell.qtysell*sell.price) as Sells from Seller left join buyfromseller on left join sell on sell.fkseller=seller.idseller group by seller.nameseller)
group by nameseller Sent from Yahoo Mail on Android
