hibernate-devel

[Hibernate] left outer join

[Stasa J. <sta...@da...>]

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=3Ds.SBLS where b.sbls like '%N710900%'

The two tables are not in relation to each other. They both have only =
one column that is the same and this is SBLS.

How can I execute this statement in Hibernate.

Greeting,
Stasa

Re: [Hibernate] left outer join

[Max R. A. <max...@jb...>]

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 not in relation to each other. They both have only  
> one column that is the same and this is SBLS.
>
> How can I execute this statement in Hibernate.
>
> Greeting,
> Stasa
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting  
> language
> that extends applications into web and mobile media. Attend the live  
> webcast
> and join the prime developer group breaking into this new coding  
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel



-- 
--
Max Rydahl Andersen
callto://max.rydahl.andersen

Hibernate
ma...@hi...
http://hibernate.org

JBoss Inc
max...@jb...