1、sele ct 委托编号,{样品信息表}.样品编号,样品名称,样品原号 From {样品信息表} Inner JOIN {试样信息表} ON {试样信息表}.[样品编号] = {样品信息表}.[样品编号] where {样品信息表} .[_identify] is null group by 委托编号,{样品信息表}.样品编号,样品名称,样品原号
2、"select * from {表A} where xx列 in ('" & string.join("','",list1.toarray) & "')"