AnsweredAssumed Answered

Help with Query

Question asked by stephen_floyd on Feb 6, 2014
Latest reply on Feb 6, 2014 by stephen_floyd

Hi

I am trying to add a column to an existing lookup dynamic query but when I preview it the results are duplicated so many times (32529 times to be precise). I should only get 7 names in the results. Here is the code. Can you advise why I am getting pages upon pages of the same resources ?

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@,
@SELECT:Q.prisopen:prisopen@ - this is the line I have added

FROM SRM_RESOURCES RESOURCES,PRJ_RESOURCES Q, from this table
CMN_SEC_USERS U,
CMN_SEC_USER_GROUPS G,
CMN_SEC_GROUPS V

WHERE RESOURCES.USER_ID = U.ID
AND G.USER_ID = U.ID
AND V.ID = G.GROUP_ID
AND V.GROUP_CODE = '***_xxxxxxxx' - (blocked for security reasons) 
AND @FILTER@

 

Thanks

Stephen F

Outcomes