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
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
This is my first ever post to a newsgroup, so I hope I get it right.
I've got the basics of OJB down, but now I am attempting to do some fairly
nested joins and OJB is not producting the SQL
statements I know I need (i.e. I've written them manually before).
This is about what I need:
SELECT DIS