Hi
I have 2 tables
Purchase Table - ItemCode, Qty Recd
Issue Table - ItemCode, Qty Issued
I want to group Data by ItemCode and then display data like below
ItemCode Qty Recd Qty Issued Qty Balance
1 10 2 8
2 4 4
Thanks