select OS.Caption0, CS.SystemType0, Count(*)from dbo.v_GS_COMPUTER_SYSTEM CS Left Outer Join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceIdGroup by OS.Caption0, CS.SystemType0Order by OS.Caption0, CS.SystemType0