日期:2014-05-18  浏览次数:20762 次

访问Access中SQL语句语法错误 (操作符丢失)?
String   sql=new   String( "SELECT   titles.isbn,title,editionNumber, "   +
      "copyright,publisherID,imageFile,price   "+ "FORM   titles   "+
      "WHERE   isbn   in   (select   isbn   from   authors   join   authorISBN   on   authorID "   +
      "   where   authors.firstName   =   ' "+k+ " '   or   authors.lastName=   ' "+k+ " ') "   +
      "   or   title   like   '% "+k+ "% ' ");  

[Microsoft][ODBC   Microsoft   Access   Driver]   语法错误   (操作符丢失)   在查询表达式   'price   FORM   titles   WHERE   isbn   in   (select   isbn   from   authors   join   authorISBN   on   authorID   where   authors.firstName   =   'C '   or   authors.lastName=   'C ')   or   title   like   '%C% ' '   中。

难道Access中不支持%   的百分号模糊查询么?
请教!

------解决方案--------------------
FROM not FORM