访问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