Julien Martin <[EMAIL PROTECTED]> wrote:
>I have a sql query as follows:
>
>**
>SELECT
> DB_ESTABLISHMENT_NAME,
> AVG(DB_GRADE)
>
>FROM
> ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON
>ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID
>
>WHERE
> AV
I believe you have to add your AVG() to your GROUP BY clause.
> I have a sql query as follows:
>
> **
> SELECT
> DB_ESTABLISHMENT_NAME,
> AVG(DB_GRADE)
>
> FROM
> ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON
> ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_I
Your where clause is confusion. Are you wanting to retrieve rows where the
DB_Grade is greater than 2? AVG(DB_GRADE) is not a valid restriction. Are
you wanting HAVING AVG(DB_GRADE) > 2 ?
-Original Message-
From: Julien Martin
To: '[EMAIL PROTECTED]'
Sent: 5/5/04 12:12 PM
Subject: Use of A
On Wed, 5 May 2004 19:12:00 +0200
Julien Martin <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a sql query as follows:
>
> **
> SELECT
> DB_ESTABLISHMENT_NAME,
> AVG(DB_GRADE)
>
> FROM
> ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON
> ES.DB_
At 19:12 +0200 5/5/04, Julien Martin wrote:
Hello,
I have a sql query as follows:
**
SELECT
DB_ESTABLISHMENT_NAME,
AVG(DB_GRADE)
FROM
ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON
ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID
WHERE
AVG(DB_G
