Subject | Re: [firebird-support] [Qry][Err:-206]Column does not belong to referenced table(SOLVED) |
---|---|
Author | Andrea Raimondi |
Post date | 2006-02-08T22:20:03Z |
Alexandre Benson Smith wrote:
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
Andrew
> Andrew,Alexandre,
> like this:Some tweaking led to this:
>
>[SNIP query]
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