[求助]SQL取自己表的列不重复数据 Post By:2019/12/23 20:27:00 [只看该作者]
Dim cmd As new SQLCommand Dim Sqldt As DataTable cmd.C cmd.CommandText = "Sele ct b.*,(Sel ect DISTINCT 排产单号 from {订单表视图} as a where a.物料内码 = b.物料内码 and a.排产单号 is not null) as 旧单单号" cmd.CommandText &= " from {订单表视图} as b "