Forum
Merhaba
aşağıdaki gibi bir sorgu yazdımım. sorgu çalııyor. öğrenmek istediğim MODE.AD kısmında tekrar eden veriler var. ben sadec bu sütunda
tekrar eden satırı nasıl engellerim
select MODE.AD , model.Model00, memory.TotalPhysicalMemory00, model.Manufacturer00, model.MachineID, detay.Name00,
isletim.Caption00, client.User_Name0
FROM [CM_TOM].[dbo].[Computer_System_DATA] as model inner join [CM_TOM].[dbo].[Processor_DATA] as detay
on model.MachineID = detay.MachineID inner join [CM_TOM].[dbo].[PC_Memory_DATA] as memory on detay.MachineID = memory.MachineID
inner join [CM_TOM].[dbo].[Operating_System_DATA] as isletim on detay.MachineID = isletim.MachineID
inner join [CM_TOM].[dbo].[Computer_System_DATA] as kullanici on kullanici.MachineID = detay.MachineID
inner join [CM_TOM].[dbo].[v_CH_ClientSummary] as summary on summary.ResourceID=detay.MachineID inner join [CM_TOM].[dbo].[vSMS_R_System] as client on client.ItemKey = detay.MachineID
eyvallah