Hello Every Body:

I wrote a HQL Query, like this:
[b]select order.name, order.status.name from order[/b]

In order to the bussiness logic, a order may have no status, so the status name have to be null or "".

When i execute the query, the hibernate got show all "orders" that have status values, but no tha orders which have no status.

¿How can I do to reemplaze the null value of propery status in the object Order?

status (id, name)
id name
===========
1 Sended
2 Reserved

order(id, name, idStatus)
id name idStatus
==================
1 o1
2 o2 2

The response ideal:

o1, "" (spaces)
o2, Reserverd.

Can some one help me?

Thank for your help.

Regards. Neketsu Shonen

Something like this
Select o.name , s.name
from Order o left outer join o.status s

http://www.hibernate.org/hib_docs/v3/re ... yhql-joins

Hello Friend:

Thank for your help. Thats helpme a lot.

Thanks.