Thank you very much for your answer, Michael! Yes, what Cheyenne tried to use was simply not the right grammar.
Thanks, Maryann On Mon, Sep 19, 2016 at 10:47 AM, Michael McAllister < mmcallis...@homeaway.com> wrote: > This is really an ANSI SQL question. If you use an aggregate function, > then you need to specify what columns to group by. Any columns not being > referenced in the aggregate function(s) need to be in the GROUP BY > statement. > > > > Michael McAllister > > Staff Data Warehouse Engineer | Decision Systems > > mmcallis...@homeaway.com | C: 512.423.7447 | skype: michael.mcallister.ha > <zimmk...@hotmail.com> | webex: https://h.a/mikewebex > > This electronic communication (including any attachment) is confidential. > If you are not an intended recipient of this communication, please be > advised that any disclosure, dissemination, distribution, copying or other > use of this communication or any attachment is strictly prohibited. If you > have received this communication in error, please notify the sender > immediately by reply e-mail and promptly destroy all electronic and printed > copies of this communication and any attachment. > > > > *From: *Cheyenne Forbes <cheyenne.osanu.for...@gmail.com> > *Reply-To: *"user@phoenix.apache.org" <user@phoenix.apache.org> > *Date: *Monday, September 19, 2016 at 10:50 AM > *To: *"user@phoenix.apache.org" <user@phoenix.apache.org> > *Subject: *Re: Using COUNT() with columns that don't use COUNT() when the > table is join fails > > > > I was wondering because it seems extra wordy >