title: sql select statement, guide to correct select statement
body: <p>I should  write a SQL query that will select all of the books that are currently checked out and are past due to be returned, which have a value greater than $10.00 from a library system. I should return  the name, address, postal code, and phone number of the borrower, the name and phone number of the librarian responsible for the transaction, the date the book was due to be returned, and the name, cost, and ISBN number of the book. And  my query should be sorted  the list by the return date in descending order.</p>
  
  <p>This is what i wrote</p>
  
  <pre><code>Select a.returndate as booklended ,a.isbn_number as booklended, b. as borrower,          
                      b.address as borrower, b.postalcode as borrower, b. phonenumber as 
                      borrower, c.name as     librarian, c.phonenumber as librarian
                  from booklended.a, librarian.c, borrower.b
     where a. librarian id= c.librarianid
         and a.librarycard = b.librarycard
           and returndate &lt; curdate()
           and cost  &gt; 10.00
                  order by a. returndate desc;
  </code></pre>
  
  <p>However I am getting this error
          5: invalid schema name: BOOKLENDED in statement [Select a.returndate as booklended ,a.isbn_number as booklended, b. as borrower, b.address as borrower, b.postalcode as borrower, b. phonenumber as borrower, c.name as librarian, c.phonenumber as librarian</p>
  
  <p>from booklended.a]</p>
  
  <p>Could I please get a guide on how I may correct this. Thank you</p>