[b]Hibernate version:[/b]

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b]

[b]Debug level Hibernate log excerpt:[/b]

Hi,

I have three tables A, B and i want to write query like this

select a,b from A as a, B as b
where a.x=1 and
a.y = b.y (+) --> y may be not available in table b
and b.z.id =0 ( z may be be null or reference to another object/table).

I want the query to return the records if b.z is null or b.z.id = 0

How can i write this query in HQL?

Thanks,

something like


this work if a is associated to b via many-to-one and will return object[]


but this can be wrong, it would be better to show us mapping files