"SELECT * FROM NC_daily WHERE title in (select cstr(OID) from [NC_objInfo] where ShipNumber like '%" + key + "%' or EnglishName like '%" + key + "%' or Nationality like '%" + key + "%') or BasicDesc like '%" + key + "%' or Suggest like '%" + key + "%' order by CreatTime desc";
查询语句如上,title开始是备注类型
就报标题那个错
把title的数据类型由“备注”改成“文本”后解决了此问题
深层原因不清楚....