why Hibernate doesn't support extyernal join ?

belcore · **Joined:** Mon Sep 01, 2003 10:40 am **Posts:** 17

I don't understand why Hibernate doesn't support the external joins like this

Code:

Parent table
String idParent (primary key)
Date dateParent (a parent column)
....

Child Table
String idChild (primary key)
String idParnet (external key)
Date dateChild (a child column)
..

I want a sql like this...

Code:

select * from parent,child where idParent=idChild AND dateParent =dateChild 
a

(dateParent =dateChild for me is a external join)

but I don't know where I can set the "AND dateParent =dateChild" clause.
I tried insert it into one-to-many where clause, without success.

michael · **Posted:** Fri Feb 27, 2004 7:40 am

This is a planed feature for some of the next releases.

emmanuel · **Posted:** Mon Mar 01, 2004 11:59 am

And this was not supported from the begining, because it often sounds like a wrong DB schema.