Discussion :

[stacre]

bonjour
j'ai la requete suivant :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
 
String queryString ="SELECT s FROM " + ReachDeclarationImpl.class.getName()
                    + " rd INNER JOIN rd.supplier s"   
                    + " WHERE rd in (SELECT distinct rd3 FROM " + ReachDeclarationImpl.class.getName() + " rd3 INNER JOIN rd3.legalEntities le1 INNER JOIN le1.users u1 WHERE u1 is not null and u1 = :user) OR rd in ( SELECT distinct rd2 FROM " + EntityDeclarationImpl.class.getName()
                    + " ned INNER JOIN ned.reachDeclaration rd2 INNER JOIN ned.legalEntity le2 INNER JOIN le2.users u2"
                    + " WHERE (u2 is not null and u2 = :user)) "
                    + " order by upper(s.supplierName) asc";

il me raméne des doublan
qlq1 conai la solustion