问题描述:
高手帮忙看下这段select语句有没有错误,就是从一个存书表中通过ISBN号,作者,出版社,书名进行查找.
SELECT 存书.ISBN,存书.书名,存书.作者,存书.出版社
FROM 存书
WHERE (((存书.ISBN)=Forms!存书查询!ISBN) And ((存书.书名)=Forms!存书查询!书名) And ((存书.作者)=Forms!存书查询!作者) And ((存书.出版社)=Forms!存书查询!出版社)) Or (((Forms!存书查询!ISBN) Is Null) And ((Forms!存书查询!书名) Is Null) And ((Forms!存书查询!作者) Is Null) And ((Forms!存书查询!出版社) Is Null)) Or (((存书.ISBN)=Forms!存书查询!ISBN)) Or (((存书.书名)=Forms!存书查询!书名)) Or (((存书.作者)=Forms!存书查询!作者)) Or (((存书.出版社)=Forms!存书查询!出版社)) Or (((InStr(存书.ISBN,Forms!存书查询!ISBN))>0)) Or (((InStr(存书.书名,Forms!存书查询!书名))>0)) Or (((InStr(存书.作者,Forms!存书查询!作者))>0)) Or (((InStr(存书.出版社,Forms!存书查询!出版社))>0));
SELECT 存书.ISBN,存书.书名,存书.作者,存书.出版社
FROM 存书
WHERE (((存书.ISBN)=Forms!存书查询!ISBN) And ((存书.书名)=Forms!存书查询!书名) And ((存书.作者)=Forms!存书查询!作者) And ((存书.出版社)=Forms!存书查询!出版社)) Or (((Forms!存书查询!ISBN) Is Null) And ((Forms!存书查询!书名) Is Null) And ((Forms!存书查询!作者) Is Null) And ((Forms!存书查询!出版社) Is Null)) Or (((存书.ISBN)=Forms!存书查询!ISBN)) Or (((存书.书名)=Forms!存书查询!书名)) Or (((存书.作者)=Forms!存书查询!作者)) Or (((存书.出版社)=Forms!存书查询!出版社)) Or (((InStr(存书.ISBN,Forms!存书查询!ISBN))>0)) Or (((InStr(存书.书名,Forms!存书查询!书名))>0)) Or (((InStr(存书.作者,Forms!存书查询!作者))>0)) Or (((InStr(存书.出版社,Forms!存书查询!出版社))>0));
问题解答:
我来补答展开全文阅读