Mysql Uni0n All

I need some help with a Mysql Query utilizing UNION ALL. I have attached my code so you can look at what I have so far. What I am trying to do is have one SELECT be the total (or summary) and the other SELECT is the detail (summarized on Customer_Number and Order_Month). It would be nice to have a space in between each customer as well. One additional requirement is to subract one field from another and post the result as a new row of data.

Leave a Reply

Your email address will not be published. Required fields are marked *