AnsweredAssumed Answered

Dupliate Values in NSQL Lookup

Question asked by bertmartin on Jun 13, 2011
Latest reply on Jun 14, 2011 by bertmartin
I am attempting to build a lookup field based on the resources in a group. I have done this successfully in my development environment using the following lookup query:

SELECT @SELECT:RESOURCES.ID:ID@,
@SELECT:RESOURCES.LAST_NAME:LAST_NAME@,
@SELECT:RESOURCES.FIRST_NAME:FIRST_NAME@,
@SELECT:RESOURCES.FULL_NAME:FULL_NAME@,
@SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_NAME@,
@SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_CODE@

FROM SRM_RESOURCES RESOURCES,
CMN_SEC_USERS U,
CMN_SEC_USER_GROUPS G,
CMN_SEC_GROUPS_V V

WHERE RESOURCES.USER_ID = U.ID
AND G.USER_ID = U.ID
AND V.ID = G.GROUP_ID
AND V.GROUP_NAME = 'IS Manager (Lookup)'
AND @FILTER@


However, when I use this same query in my Production environment all of the reources in teh group are duplicated mulitple times (about 15). All of the records look exaclty the same. Is there a way to get unique vlaues in an nsql?

Thanks for any help.

Outcomes