Problem with my left join fetch query

SimonH · **Joined:** Thu Sep 08, 2005 12:15 pm **Posts:** 17

Hi ihave this Hql query and i dont know how tio make it work anybody could help me?? Everything is fine unless I put something in the where clause that is referencing on a Class that is left join. e.g : in this case if I dont put t.IdType = 2 it works fine but when its in the query i get an error.

Code:

select count(m) from MediaRadio as m left join fetch m.TypeMedia as t where m.Nom LIKE '%ck%' AND t.IdType = 2

I get this Error

Code:

Column 'typemedi1_.IdTypeMedia' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

thank you
Simon[/quote]

KPixel · **Posted:** Sat Sep 10, 2005 9:00 am

Try

Code:

select count(m) from MediaRadio as m where m.Nom LIKE '%ck%' AND m.TypeMedia.IdType = 2

SimonH · **Joined:** Thu Sep 08, 2005 12:15 pm **Posts:** 17

Thanks for the reply but i would like to use the left join fetch because TypeMedia as t is a many-to-one relation and i would like the TypeMedia to be retreive in a single sql statement with my MediaRadio. In fact i have a lot more many-to-one relation then that but i simplified the query for the post. What I would like to know is if its possible to have something in the where clause that that is also fetche e.g: the class "t" is mark as fetch and i also have a condition on a field of this class ( t.IdType = 2).

Simon