openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Sutter <kwsut...@gmail.com>
Subject Re: Join Tables by value
Date Wed, 04 Feb 2009 14:01:19 GMT
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 <masterperas@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message