Hello.

I have a basic question. Can I use HQL to create a temporary table in the FROM clause of a select statement and then join the temporary table with another table in the same select clause.

My native SQL (Oracle 8i) is as follows:

select a.* from address_validation a,
(select min(av_seqno) seqno, av_zipcode, av_state, av_city from address_validation where av_zipcode = 97230 group by av_zipcode, av_state, av_city) b
where a.av_zipcode = b.av_zipcode
and a.av_state = b.av_state
and a.av_city = b.av_city
and a.av_seqno = b.seqno.

I would like to convert this to an HQL. But, when I convert it, I get an Query exception with the message "in expected".

Can anyone help me to solve this problem.

Thanks a lot in advance.

Sorry not supported. Maybe in the future for Hibernate 3 though portablity could be an issue.

Are temporary tables now supported???


How can I use temporary tables in HQL?


Something like (SQL):




So you see, I need a temporary table that values are available in another table in the same Query.

Any suggestions?