[Hibernate] left outer join

2006-04-18 Thread Stasa Jerinic
Hallo, can help me somebody. I wan't to to execute following MySQL-statement in hibernate: SELECT b.*, s* FROM bbp_test.BLSBAS b left outer join bbp_test.BLSSTR s on b.SBLS=s.SBLS where b.sbls like '%N710900%' The two tables are not in relation to each other. They both have only one column that

Re: [Hibernate] left outer join

2006-04-18 Thread Max Rydahl Andersen
please go to forum.hibernate.org for user questions. /max Hallo, can help me somebody. I wan't to to execute following MySQL-statement in hibernate: SELECT b.*, s* FROM bbp_test.BLSBAS b left outer join bbp_test.BLSSTR s on b.SBLS=s.SBLS where b.sbls like '%N710900%' The two tables are no