hi,


i'm using createQuery("select...") for my project, i have a situation using left Outer join,

compare with left table non primary key column and right table primary key column,

Tables as follows



Table A
AA --> Mapped as one to Many

Table B
EEE --> Mapped as one to many
AA --> Mapped as Many to one

I need to write Query like this

createQuery(" from A left outer join B on A.CC=B.EEE");

In hibernate how can i solve It, i need some help,

thank,