[GENERAL] unexpected 'aggregates not allowed in where clause' error

2005-03-03 Thread L. Fletcher
Hello, I am getting a strange "aggregates not allowed in where clause" error when I try to execute the below query: SELECT n.note, pr.property_id AS PropertyID FROM property.note n INNER JOIN property.rating_note rn ON rn.note_id = n.note_id INNER JOIN property.propertyrating pr ON

Re: [GENERAL] unexpected 'aggregates not allowed in where clause' error

2005-03-03 Thread Tom Lane
L. Fletcher [EMAIL PROTECTED] writes: I am getting a strange aggregates not allowed in where clause error = when I try to execute the below query: SELECT n.note, pr.property_id AS PropertyID FROM property.note n INNER JOIN property.rating_note rn ON rn.note_id =3D