Hi. I'm trying to build a query to show activities to see unique activities per business partner. I want the CardCode to be the unique field - only show 1 row per CardCode. I tried using Distinct on the CardCode field to no avail. Here's my query:
SELECT T0.[ClgCode] AS 'Activity #', T2.[CardCode] AS 'BP Code', T2.[CardName] AS 'BP Name', T0.[Recontact] AS 'Start Date', T0.[endDate] AS 'End Date', T0.[CntctDate] AS 'Creation Date', T0.[CntctTime] AS 'Creation Time', T4.[Name] AS 'Subject', CASE WHEN T0.[Closed] = 'Y' THEN 'Closed' ELSE 'Open' END AS 'Status', T0.[Details] AS 'General Subject', T0.[Notes] AS 'Detailed Notes', T3.[Name] AS 'Contact Person' FROM OCLG T0 INNER JOIN OUSR T1 ON T0.[AttendUser] = T1.[USERID] INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode LEFT OUTER JOIN OCPR T3 ON T0.[CntctCode] = T3.[CntctCode] LEFT OUTER JOIN OCLS T4 ON T0.CntctSbjct = T4.[Code] WHERE (T0.[CntctDate] BETWEEN '[%0]' AND '[%1]') AND T1.[USER_CODE] = '[%2]'
Thanks so much for your help!