Member Avatar for cybernaut09
cybernaut09 0 Newbie Poster

I am using java and ms access . Now I have two tables
1. issuedBooks - bookID, userName, issueDate, returnDate, fine
2. book - bookID, name, author, edition, cost , publisher

now I want to show issued books in a table in java . So I used this SQL query but it is giving error and I am not able to solve it.

SELECT  issuedBooks.bookID, book.name, book.author, book.publisher, book.edition, book.isbn, book.cost, issuedBooks.issueDate, issuedBooks.returnDate, issuedBooks.fine FROM issuedBooks INNER JOIN book ON issuedBooks.bookID=book.bookID  WHERE  userName='"+<%=a.get(0)%>+"'

here

'"+<%=a.get(0)%>+"'

is for userName for member

Please help in solving the problem.

  • 1 Contributor
  • 0 Replies
  • 70 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.