• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HQL 2. Left outer join of 2 UNRELATED entities

 
John Landon
Ranch Hand
Posts: 228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have 2 hibernate objects.
A
id|name|bid

B
bid|address

eventually I need all the rows form table a that do not have an address. BUT the tables are not explicitly related (in the hbm). I just know that bid in both is the same thing. bid in B is the key of it.
so I need to do left outer join and something equals null at the end.

Heeeelp :-).

Thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic