Can you show mappings?
On Jul 10, 11:12 am, spiralni <[email protected]> wrote:
> Hi..
>
> I'd like to perform a join between two entities..
>
> [Operator] has many [Client]
>
> I can do this with this SQL sentence
>
> select c.*, o.name from clients c join operators o on c.operator =
> o.id
>
> I would like to do this same query using HQL, for this I use this HQL
> query
>
> "from Client c join fetch c.Operator where c.Status = :status and
> c.Cif in (:cifs)"
>
> The HQL query results in
>
> select (fields names goes here)
> from dbo.clients client0_ inner join dbo.operators operator1_ on
> client0_.Operator = operator1_.Id
> where (client0_.Status = 1) and (client0_.Cif in (12345670 ,
> 12345678 ))
>
> which is ok, but also execute a new query for every operator id that I
> have (in my case I have 2 operators)
>
> SELECT (fields names goes here)
> FROM dbo.clients clients0_
> WHERE clients0_.Operator = 2
>
> SELECT (fields names goes here)
> FROM dbo.clients clients0_
> WHERE clients0_.Operator = 1
>
> Which is not desirable... Why is this happening..? I just want to
> execute the first query..
>
> Hope you can help me..
>
> Thanx
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
