You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@openjpa.apache.org by Nuno Furtado <ma...@gmail.com> on 2009/02/03 11:01:01 UTC

Join Tables by value

Good day to all,

i have the following tables :

SATAFIL0:
                 integer id
                 short domValue

SATADOM0:
                 string domid
                 short domValue

is there any way i can do a join between these two tables, considering the
domid value is not present on any table column in SATAFIL0?


 \    / \    Nuno Furtado
  )  (  ' )
 (  /    )   http://twitter.com/sapiens
  \(__ )|   http://hubpages.com/profile/sapiens

Re: Join Tables by value

Posted by is_maximum <mn...@gmail.com>.

I am eager to know if it is possible. I had such problem and eventually ended
up that it's impossible because there is no such relationship defined in
Sun's spec but hope if it's possible in OpenJPA.





Nuno Furtado wrote:
> 
> Good day to all,
> 
> i have the following tables :
> 
> SATAFIL0:
>                  integer id
>                  short domValue
> 
> SATADOM0:
>                  string domid
>                  short domValue
> 
> is there any way i can do a join between these two tables, considering the
> domid value is not present on any table column in SATAFIL0?
> 
> 
>  \    / \    Nuno Furtado
>   )  (  ' )
>  (  /    )   http://twitter.com/sapiens
>   \(__ )|   http://hubpages.com/profile/sapiens
> 
> 

-- 
View this message in context: http://n2.nabble.com/Join-Tables-by-value-tp2263817p2267421.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Join Tables by value

Posted by Kevin Sutter <kw...@gmail.com>.

Nuno,
Why are you interested in doing a join?  There must be some relationship
between these two entities/tables, although not an explicit relationship.
In this case, you might be able to perform a "join" via the WHERE clause.
But, I don't understand your need for a join operation.

Thanks,
Kevin

On Tue, Feb 3, 2009 at 4:01 AM, Nuno Furtado <ma...@gmail.com> wrote:

> Good day to all,
>
> i have the following tables :
>
> SATAFIL0:
>                 integer id
>                 short domValue
>
> SATADOM0:
>                 string domid
>                 short domValue
>
> is there any way i can do a join between these two tables, considering the
> domid value is not present on any table column in SATAFIL0?
>
>
>  \    / \    Nuno Furtado
>  )  (  ' )
>  (  /    )   http://twitter.com/sapiens
>  \(__ )|   http://hubpages.com/profile/sapiens
>