Mysql error message

[hawthorne]

Hi,
I am written the follwing query:
select tbl_raterule.,tbl_property., tbl_propertyfeature., tbl_propertyphoto.nme_photo, tbl_propertyphoto.nme_caption, tbl_propertyphoto., tbl_property.id_property FROM tbl_property LEFT JOIN tbl_propertyfeature ON ( tbl_propertyfeature.id_property=tbl_property.id_property ) LEFT JOIN tbl_propertyphoto ON (tbl_property.id_property=tbl_propertyphoto.id_property and tbl_propertyphoto.flg_main ='1') LEFT JOIN tbl_raterule ON (tbl_property.id_property=tbl_raterule.id_property) where tbl_property.flg_active=1 group by tbl_property.id_property order by min(tbl_raterule.val_rate),max(tbl_raterule.val_rate)

which on execution gives the error:
#1111 - Invalid use of group function

I am using MySQL 3.23.58

Thank You

[kakki]

i think, if you "group by" anything, then you dont have a single entry in the table
but multiple entries, if they are all the same, you can use sth. like MIN(value) on the table..

example:
id value points
1 tom 3
1 tom 2
2 pete 5

then sql-statement like this:

SELECT id,value,sum(points) FROM table GROUP BY id

will be handled like
2 rows( 2 different ids )

row 1:

id: 1,1
name:tom,tom
points:3,2

row 2:

id: 2
name: pete
points:5

so.... in row one, there's a multiple "tom" in the values, you can choose MIN() or MAX()
to show one like:

SELECT MIN(id),MIN(name),sum(points)
FROM table
GROUP BY id

[bogu]

Can u explain this?

order by min(tbl_raterule.val_rate),max(tbl_raterule.val_rate)