hibernate left join not working

[Pranav Sharma]

I use the following query in Hibernate for a left join between table1 and table2.

  queryString.append(select cv.field  from table1 as cv LEFT JOIN table2 as cl on cl.id = cv.id");
List l = session.createQuery(queryString.toString()).list();
[CODE]
 
but i get the following exception:
 
[CODE] net.sf.hibernate.QueryException: outer or full join must be followed by path expression  

Can someone help me with this.
[ October 21, 2005: Message edited by: mannu kapoor ]

[Scott Johnson]

Do your mapping files have an association defined between objects table1 and table2? If not that could be your issue.

[Lucian Ochian]

The way that you wrote the query it seems to be an SQL query and not an HQL query.
Using session.createQuery, you need to provide to this method a HQL query, and not a SQL query.
You can use session.createSQLQuery with a SQL query, or write your query as a HQL query, something like:

select cv.field from table1 alias1 JOIN alias1.x alias2, where x is your association element in the first class.

Hope this helps!
[ November 16, 2005: Message edited by: Lucian Ochian ]