MySQL Forums
Forum List  »  Newbie

Re: MYSQL Query re multiple counts
Posted by: Peter Brawley
Date: August 09, 2017 07:03AM

> I do not know how to align the data to the column headings

Surround with BBCode code tags.

> join my 2 queries together and add another column called

The first query sums over year,month; the second sums over year only. Your requirement needs to state the rules for generating month totals in the combined query.

About your column names, proper casing can wreak havoc on Linux; best stick with lower case column names.

Options: ReplyQuote


Subject
Written By
Posted
Re: MYSQL Query re multiple counts
August 09, 2017 07:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.