做了一个多条件的SQl语句,为简化用 Filter 存储子查询的条件,如 Filter = [客户价值] In ( '低','中') And [责任人] in ('George')
但下面这句总是显示错误,如何在最后增加 与SELECT 前对应的双引号" ?
cmd.CommandText = "SELECT * From {联系人信息} WHERE 移动电话 IS NOt NULL And 客户代码 In (Select 客户代码 From {客户信息} Where & Filter & ")"