Click here to Skip to main content
15,913,773 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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)

SQL
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'


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

what is themistake i have done
Posted
Updated 15-Jan-13 20:30pm
v2

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900