Hi,
with HQL I try to select single columns of a Class like

select line.id, line.name, line.description from a.b.c.Line line where ...

This usually works fine, also when selecting colums from many-to-one-relations, etc.
Now I have a problem with nullable columns:
I have 2 classes "Service" and "Provider" and have a many-to-one-relation in Service pointing to Provider (field "provider") with Provider als nullable property.
The HQL select statement

select srv.id, srv.name, srv.provider.name from a.b.c.Service srv where ...

only returns entries where provider is not null. Selecting prv.service returns the same result, selectig the entries without the column from service returns the right result set.
In my hibernate configuration use_outer_join is set to true.

Any ideas why this works fine with other "simple" nullable columns and with non-nullable references but not with nullable references?

Any help would be appreciated,
Wolfgang

look at the generated SQL and you will understand ... then look at the HQL join syntax.