Arno,
Thanks for your pointing out the issue with my SQL statement.
Mike
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, April 06, 2016 4:36 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] SQL Error Code -104
Tomasz,
Thanks for your guidance and explanation for a much simpler solution.
Mike
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, April 07, 2016 2:58 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] SQL Error Code
On 06.04.2016 o 22:03, 'stwizard' stwiz...@att.net [firebird-support] wrote:
> SELECT DISTINCT P.AREA_CODE, P.PHONE_NO,
>
>(SELECT COUNT(*)
>
> FROM PHONE P2
>
> WHERE P2.PHONE_ID = P.PHONE_ID) AS CNT
>
>FROM PHONE P
>
> WHERE P.AREA_CODE IS NOT NULL
>
> GROUP BY
Hi,
The message doesn’t tell you which expression is not contained in an aggregate
function or GROUP BY clause, but is very clear that it is “P.PHONE_ID”
Not sure what you trying to achieve, but your SQL is indeed invalid, because
there can be multiple PHONE_ID’s per AREA_CODE, PHONE_NO
Kind
