delpouve wrote:
have read twice the doc about sql query?

Sorry, i didnot post the entire query.

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");

I need to get the data from both the tables customer and customer group. No where in the hibernate reference an example is given to get the data from multiple tables using the createSQLQuery statement with left outer join.

Can you please help me out.

please stop duplicating posts in the forum