brian0031的专栏

select distinct b.oldid,max(b.unit)   --max(b.unit)是重点 from [MBOM] a join MaterialData b on a.[Component] = b.[NewId]  where a.[Processing]

DataView可以帮我们直接获取Distinct数据DataTable dataTable;DataView dataView = dataTable.DefaultView;DataTable dataTableDistinct = dataView.ToTable(true,"FieldName1","FieldName2","...");//注：其中ToTable()的第一个参