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:Q.prisopen:prisopen@ - this is the line I have added
FROM SRM_RESOURCES RESOURCES,PRJ_RESOURCES Q, from this table
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)