Andrew,

Andrea Raimondi wrote:

> Like this?
>
> select Messages.*,avg(MessageRatings.ratingvalue) as AvgRate from Messages
> join messageratings mg on mg.message_id = Messages.message_id
> group by Messages.* order by AvgRate
>

like this:

select
M.Message_ID, M.Date, M.Suject, M.Sender, M.To, avg(MR.RatingValue)
from

from
Messages M join
MessageRatings MR on (MR.Message_id = M.message_id)
group by
M.Message_ID, M.Date, M.Suject, M.Sender, M.To
order by
6

note that "6" are the position of the columns that has the average value.

>
> Cheers,
>
> Andrew
>

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br