Index: topia2/src/java/org/codelutin/topia/generator/DAOAbstractGenerator.java
diff -u topia2/src/java/org/codelutin/topia/generator/DAOAbstractGenerator.java:1.18 topia2/src/java/org/codelutin/topia/generator/DAOAbstractGenerator.java:1.19
--- topia2/src/java/org/codelutin/topia/generator/DAOAbstractGenerator.java:1.18	Fri Dec  7 08:24:10 2007
+++ topia2/src/java/org/codelutin/topia/generator/DAOAbstractGenerator.java	Fri Dec  7 16:25:54 2007
@@ -24,9 +24,9 @@
 * Created: 12 déc. 2005
 *
 * @author Arnaud Thimel <thimel@codelutin.com>
-* @version $Revision: 1.18 $
+* @version $Revision: 1.19 $
 *
-* Mise a jour: $Date: 2007-12-07 08:24:10 $
+* Mise a jour: $Date: 2007-12-07 16:25:54 $
 * par : $Author: ruchaud $
 */
 
@@ -320,7 +320,7 @@
                     query = "select " + attributeName + ".topiaId from " + clazz.getQualifiedName() + " where topiaId = :id";
                     daoClass = clazz.getAttribute(attributeName).getClassifier().getQualifiedName();
                 } else {
-                    query = "select at.topiaId from " + clazz.getQualifiedName() + " cl, " + className + " at where topiaId = :id and at." + attributeName + " in cl";
+                    query = "select at.topiaId from " + className + " at inner join at." + attributeName + " cl where cl.topiaId = :id";
                     daoClass = className;
                 }
 /*{             resultPermissions.addAll(getRequestPermission(topiaId, <%=actions%>, "<%=query%>", <%=daoClass%>.class));