Subject Re: [firebird-support] [Qry][Err:-206]Column does not belong to referenced table(SOLVED)
Author Andrea Raimondi
Alexandre Benson Smith wrote:
> Andrew,

Alexandre,

> like this:
>
>[SNIP query]

Some tweaking led to this:

select
M.Message_ID, M.Subject, avg(MR.RatingValue)
from
Messages M join
MessageRatings MR on (MR.Message_id = M.message_id)
group by
M.Message_ID, M.Subject
order by
3

Which is finally working :D

> see you !

Thank you to all who partecipated to my question, really thank you!

Andrew