Hi People,

I'm using MySql version 4.0.25 and have a formula field on one of my properties that has this sub query in it:

<property name='Rating' type='Decimal' column='Rating'
formula='(select avg(rating.Value) from rating where rating.LinkId = Id)' />

Now I only discovered recently that MySQL version < 4.1 doesn't support sub queries :( is there a work around so I can still specify it in my mapping without having to change my code? maybe use an inner join for the avg rather than a sub query?

Really apprciate your help!
-Alex

PS Nhibernate is awesome, I have tried nearly every ORM and this one is still the best by miles! :)

NHibernate version:1.2.0.Alpha1
Name and version of the database you are using: MySql '4.0.25-nt-max'