Hibernate version:
3.1.2

Hi,
I need to know if it's possible to write an HQL outer join for two tables for which there is no many-to-one relationship defined in mapping files.

Eg
Table CUSTOMERS
ID Long
NAME String
ADDRESS String
COUNTRY String ("IT", "US", "CA", "UK" etc.) <== Not defined as Country object

Table COUNTRIES
COUNTRY String (e.g. "IT", "US", "CA", "UK", etc.)
DESCRITPION String

I need to get all customers, and for each customer the description of the country (if CUSTOMER.COUNTRY field is not null)

In SQL the statement is:
SELECT CUSTOMERS.*, COUNTRIES.* FROM CUSTOMERS LEFT OUTER JOIN COUNTRIES ON CUSTOMERS.COUNTRY=COUNTRIES.COUNTRY

What's the corresponding in HQL considered that there is no hibernate relationship between these two tables?

Thanks in advance,
Davide.

HQL does not support joining objects if relationships are not defined in the mappings.

Native SQL support should help you
http://www.hibernate.org/hib_docs/v3/re ... rysql.html