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]
