Hi All

I am using Hibernate version2 & the createSQLQuery.

The createSQLQuery works fine when i retreive all the columns from the underlying table something like this

Select rdl.* from <table_name> where rdl.deal_date = blah blah

But now I want to do something like this

select rdl.deal_date from <table_name> where blah blah

but this fails with the following error
***********************
No column name found for property deal_date
**********************
when the same thing works when I qualify it in the where clause
but the moment I have it in the select list it fails

Do post your thoughts on the same

Regards