Access数据库中的内部联接 [英] Inner join in Access database

问题描述

我有三张三张桌子

1.图书馆（存储图书信息）

2.发行书（商店发行书籍信息）

3. libraryreg（存储库中注册的信息）

I have three three tables
1. library(which stores book information)
2. issuebooks(store issue books info)
3. libraryreg(which stores info of registered in library)

select library.btitle,library.bauther,library.btag , issuuebo0ks.Enrollmentno ,libraryreg.sname,libraryreg.ssec,libraryreg.ssem,libraryreg.scourse  from(( library inner join issuebo0ks on issueboks.bookno=library.bookno) inner join libraryreg on libraryreg.Enrollmentno=issuebooks.Enrollmentno)  where library.bstatus='Issued'

当我运行此查询时出现一个对话框框显示输入issuuebo0ks.Enrollmentno的值;



我做了什么

when i run this query a dialog box is show for entering the value of issuuebo0ks.Enrollmentno;

what is themistake i have done

推荐答案

查询中有很多拼写错误。



例如，issuuebo0ks拼写为issuebo0ks（零而不是o）在一个地方发行另一个地方的问题！



请更正并尝试



Milind

There are lots of spelling mistakes in the query.

For example, issuuebo0ks is spelled as issuebo0ks (there is zero instead of o) at one place issueboks at another place !

Please correct and try

Milind

这篇关于Access数据库中的内部联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！