Hello all,
I am new in this database world and my question is that I want to generate one ERP report for client in this format :
Name Email Subtotal Shipping Total Created at
#71410 103034006@qq.com 162.22 42 204.22 2015-12-11 06:04:21 +0100
#71410 103034006@qq.com 2015-12-11 06:04:21 +0100
#71410 103034006@qq.com 2015-12-11 06:04:21 +0100

There are six columns in which I have to produce my output. I want to show the subtotal which is sum of three products,total which is sum of subtotal and shipping in one single row. I don't want to show subtotal,shipping and total in all the three rows. Please help me. Before this ERP report client had asked me to show the output in single row. So by using group concat i was able to show the correct output. But now I have to show report in this format. Please help me in this.