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 < [email protected]> 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 > > [email protected] | C: 512.423.7447 | skype: michael.mcallister.ha > <[email protected]> | 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 <[email protected]> > *Reply-To: *"[email protected]" <[email protected]> > *Date: *Monday, September 19, 2016 at 10:50 AM > *To: *"[email protected]" <[email protected]> > *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 >
