Great! You're right. I am linking incorrectly, but to fix it is another story. Writing path expressions is still somewhat of an enigma. I even have a diagram, but it's just going to take some work. Any ideas? Thanks a bunch for the help.
"Gelhar, Wallace Joseph" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi Michael, This is your SQL (minus all the parenthesis) SELECT DISTINCT IMENU.SYSTEM_NUMBER, IMENU.LAST_UPDATED, IMENU.LAST_UPDATED_BY, IMENU.NAME, IMENU.DISABLED FROM ASSOC_IGROUP_IUSER INNER A5 JOIN IGROUP A4 ON A4.SYSTEM_NUMBER=A5.GROUP_SYSNO INNER JOIN ASSOC_IGROUP_IOBJECT A3 ON A3.GROUP_SYSNO=A4.SYSTEM_NUMBER INNER JOIN IOBJECT A2 ON A2.SYSTEM_NUMBER=A3.OBJECT_SYSNO INNER JOIN ASSOC_IOBJECT_IMENU A1 ON A1.OBJECT_SYSNO=A2.SYSTEM_NUMBER INNER JOIN IMENU A0 ON A0.SYSTEM_NUMBER=A1.MENU_SYSNO WHERE ASSOC_IGROUP_IUSER.USER_SYSNO='24' The SQL is equivalent except that it looks like your mapping on the ASSOC_IGROUP_IUSER table is mapping the USER_SYSNO to the IGROUP table. Check your repository.xml for this error. I suspect that you have the the FK mapped incorrectly on the repository descriptor. SELECT DISTINCT A0.DISABLED,A0.NAME,A0.SYSTEM_NUMBER,A0.LAST_UPDATED_BY,A0.LAST_UPDATED FROM IMCOP.IMENU A0, ASSOC_IOBJECT_IMENU A1, IMCOP.IOBJECT A2, ASSOC_IGROUP_IOBJECT A3, IMCOP.IGROUP A4, IMCOP.ASSOC_IGROUP_IUSER A5 WHERE A4.SYSTEM_NUMBER=A5.USER_SYSNO AND A3.GROUP_SYSNO=A4.SYSTEM_NUMBER AND A2.SYSTEM_NUMBER=A3.OBJECT_SYSNO AND A1.OBJECT_SYSNO=A2.SYSTEM_NUMBER AND A0.SYSTEM_NUMBER=A1.MENU_SYSNO AND (A5.USER_SYSNO = '24' ); Hope this helps, Wally --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
