Hi everyone
im having some trouble with this query.
all i want is to remove the extra submission date.Code:SELECT distinct [CLUSTER] ---- ,[UNIT] ---- ,[NAME] ---- ,[ID NUMBER] ---- ,[DATE ENGAGED] ---- ,[SERVICE NO] ---- ,[DESIGNATION] ---- ,s.[SUBMISSION_DATE] ---- FROM [just_testing].[dbo].[NoDisclosures$] ls ---- INNER join [10.10.9.54].bpm.dbo.DOI_CASEDATA s on ls.[ID NUMBER]=s.[EMP_ID_NO]
which basically means i want the latest submission date for each record.
please assist