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