Hi have the following script that returns
What i need is
I have tried using a count and distinct but always get the value 3 rather than 2
Comp COM (nolock)
left outer join CompEntity CE (nolock) on CE.CompID = COM.CompID
left outer join [dbo].[CompVerificationSource] CVF (nolock) ON CVF.compid = COM.CompID
where COM.CompID = '3825042'