Printable View
select a.lib_book_title,a.lib_book_author_name as Author,b.category_name from lib_book_details a join lib_book_categories b on b.category_id = a.lib_book_category join lib_book_issue_details c on c.lib_book_id = a.lib_book_id where c.lib_book_issued_to = '" + Globals.UserName + "'"
there is two join operator and i m confuse how to read
It's just getting one record with information from three tables. Let's say that you had a Person table, a Dog table and a Cat table. Such a query would allow you to get a single record containing the name of a person, the name of their dog and the name of their cat. Both the Dog and Cat tables would contain a PersonID column and they would be used to join those two tables with the Person table.