Inline Queries

sharik79 · **Joined:** Tue Dec 19, 2006 12:19 pm **Posts:** 4

Hi all,

I'm trying to use inline query in HQL,
like exists in Oracle's dialect and support,
for example:

Code:

select t.id, t.a, iq.rows_count
from  tab1 as t
        ,(select id, count(0) as rows_count
          from tab2
          group by id
         ) as iq
where t1.id = iq.id

but when i try to run it in HQL it fails,
and throws :

unexpected token: ( near line 1, column 57 [select t.id, t.a, iq.rows_count from tab1 as t ,(select id, count(0) as rows_count from tab2 group by id ) as iqwhere t1.id = iq.id]

Any suggestions?
thank you

batmat · **Posted:** Tue Dec 19, 2006 3:25 pm

What do you want to get as a result? You can also call your SQL as is doing session.createSQLQuery("your query");

sharik79 · **Joined:** Tue Dec 19, 2006 12:19 pm **Posts:** 4

Hi,

I know i can create an SQL Query,
but i'm trying to avoid it.
I want to stick with HQL, but it doesn't seem to support
the Inline Query.

Thank you