Thanks for all help i am facing issue while using joins
Using one sccm query
select count(distinct resourceid) as ModelCount,caption0,CSDVersion0 from [dbo].[v_GS_OPERATING_SYSTEM]
where caption0 like '%Windows Server%'
group by caption0,CSDVersion0
Data iam getting is as following
so iam getting following data, and i have made a another table with extended support dates for every windows version
select * from datesinfo
data iam getting
after doing join on both tables iam writing query this
select count(distinct OS.resourceid) as ModelCount,(dt.serverinfo),CSDVersion0,dt.Extendedsupportenddate,dt.servicepacksupportenddate from [dbo].[v_GS_OPERATING_SYSTEM] OS
inner join datesinfo dt on os.caption0=dt.serverinfo where os.caption0 like '%Windows Server%'
group by OS.caption0,OS.CSDVersion0,dt.serverinfo,dt.Extendedsupportenddate,dt.servicepacksupportenddate
iam getting one row duplicate with 672 rows, can you please explain why all data is distinct