多条件查询
vb中 怎么把下面的查询 变成一个查询 或者用for 语句 也行 只要并到一起就行
sql = "select * from A线表_temp where 姓名 like'" & List2.List(0) & "'"
sql = "select * from A线表_temp where 姓名 like'" & List2.List(1) & "'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(2) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(3) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(4) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(5) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(6) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(7) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(8) & "%'"