RcptNo Discoount ProductCode Price
111 10 1122 1000
111 10 1123 1500
111 10 1124 2000
123 20 1123 2000
124 30 1125 1000
124 30 1120 2000
I want This Result
Rcpt No:111
Discount :10
TOT price :1000+1500+2000-10=------;
By Which Query This Result can be Obtained