Hi, Everybody !

I have a small problem.

If I run a query with group by having two outer joins, there, group by is not working i suppose.

Case:
table 1 : Product master having product info
table 2 & 3 : receipt master and transaction having prod_id and qty
table 4 & 5 : despatch master and transaction having prod_id and qty

Requirement:
A Single...