left join « Oracle « JPA Q&A





1. Oracle and Left Outer Join    stackoverflow.com

I am confused about this Hibernate generated Oracle Sql. There is one user in the database, but they don't have any badges, but I am doing a left outer join ...

2. hiberate one-to-many problem, left join problem in oracle    forum.hibernate.org

hibernate 2.1.8, oracle 9 father and children is one-to-many. select * from father a left join children b on a.id = b.fatherid where b.name = 'kurt' select * from father a left join children b on a.id = b.fatherid and b.name = 'kurt' the results generated by the two sqls above is totally different. in first sql, the left join doesn't ...