1. Oracle and Left Outer Join stackoverflow.comI 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.orghibernate 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 ... |