[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    Re: Conditional Join
From:       Jakob Braeuchi <jbraeuchi () gmx ! ch>
Date:       2004-10-22 17:05:46
Message-ID: 41793DEA.7060508 () gmx ! ch
[Download RAW message or body]

hi xu,

afaik ojb cannot handle the conditional join.
btw what does the complete sql look like ?

jakob

Jay Xu schrieb:
> Hello,
> 
> I have a situation that I need to do a conditional Join. For example, 
> 
> IF OBJECT_A.type == 'B' THEN
> GET OBJECT_B with KEY(OBJECT_A.id)
> ELSE IF OBJECT_A.type == 'C' THEN
> GET OBJECT_C with KEY(OBJECT_A.id)
> END
> 
> I am using OJB to handle the DB access. I use JOIN a lot. But is there an easy way \
> in OJB to do this conditional JOIN? 
> Thanks
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]