CREATE VIEW `views_public_library_books` AS SELECT pbk.book_id, pbk.book_name, pbk.total_volume, pbk.volume_no, pbk.price, pbk.parches_date, pbk.quantity, pbk.writer_name,  pbk.book_id_no, pbk.ranking, pbk.category_id, pbk.sub_category_id, pbk.fk_almira_name, pbk.fk_row_name AS row_on, pbk.publisher, pbcat.ct_name, pbscat.sub_cat_name, pbscat.sub_cat_id, pbal.almira_name, pbal.place_details, pbal.almira_id, pbpu.pub_id, pbpu.name, pbpu.mobile, pbpu.address, pbpu.pub_email FROM pub_books AS pbk INNER JOIN pbl_book_category AS pbcat ON pbk.category_id = pbcat.category_id INNER JOIN pbl_book_sub_category AS pbscat ON pbk.sub_category_id = pbscat.sub_cat_id INNER JOIN pbl_almira AS pbal ON pbk.fk_almira_name = pbal.almira_id INNER JOIN pbl_publisher AS pbpu ON pbk.publisher = pbpu.pub_id;