Skip site navigation (1) Skip section navigation (2)

Re: aggregate function ?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: coder(at)montx(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: aggregate function ?
Date: 2007-05-18 17:47:11
Message-ID: 829651.67189.qm@web31804.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- coder(at)montx(dot)com wrote:
> 
> ERROR: missing FROM-clause entry in subquery for table "a1"
> estat SQL: 42P01
> Caràcter: 254
> 
> 
> This line ' WHERE A1.numero=11189 ' must change as this:
> 
> 'WHERE A1.compte='572000001'  as the values must be from the same 'compte'

Yes, it sounds like there is a relationship in your datamodel that I am not able to precieve
across emails.  If there is a relationship between compte and numero, you should be able to
connect this relationship up in the SQL select query.

It is hard to know what the error is being produced by. can you send the actual query that you are
posting and it resulting error message.
Regards,
Richard

In response to

pgsql-novice by date

Next:From: coderDate: 2007-05-18 18:11:35
Subject: Re: [NOVICE] aggregate function ?
Previous:From: coderDate: 2007-05-18 17:32:29
Subject: Re: [NOVICE] aggregate function ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group