Re: aggregate function ?

--- coder@montx.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