Thank you very much for your answer, Michael! Yes, what Cheyenne tried to
use was simply not the right grammar.
On Mon, Sep 19, 2016 at 10:47 AM, Michael McAllister <
> 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
> 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: *"email@example.com" <firstname.lastname@example.org>
> *Date: *Monday, September 19, 2016 at 10:50 AM
> *To: *"email@example.com" <firstname.lastname@example.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