|
select R .Name0, R .Operating_system_Name_And0 from dbo .v_R_System R Where r .ResourceId not in (Select ResourceId from dbo.v_R_System R where r.Client_Version0 <> '') and R.Operating_system_Name_And0 <> '' order by R .Name0, R .Operating_system_Name_And0
|
|
|