Hi,
Anybody pls let me know how to retrieve the selected fields from the different tables using join conditions in hibernate with some example.

the query as follows

the query is
createSQLQuery("select {cvo}.customeridvc,{cvo}.customernamevc,{cvo}.shortnamevc,{cvo}.creditstatusvc,{cgvo}.groupnamevc from customer as {cvo}
left outer join customergroup as {cgvo} on cgvo.custgroupidvc=cgvo.custgroupidvc");


Iam getting an exception when executing the above code as follows:

ERROR [STDERR] net.sf.hibernate.QueryException: Alias does not correspond to any of the supplied return aliases = {[cvo]}

Thanks for your advise on this subject

Query sqlQuery = sess.createSQLQuery("select {cat.*} from cats {cat}", "cat", Cat.class);
sqlQuery.setMaxResults(50);
List cats = sqlQuery.list();

it's in the doc you need to specify which class has to be used with your alias