Created
February 3, 2017 05:49
-
-
Save enujo/fcbc52fc300bbf1944d0e3b0e63331fe to your computer and use it in GitHub Desktop.
select sqlquery
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| book.book_no as "bookNo", | |
| book.disbook_no as "disbookNo", | |
| book.library_no as "libraryNo", | |
| book.book_name as "bookName", | |
| book.book_writer as "bookWriter", | |
| book.book_pulisher as "bookPulisher", | |
| book.book_firstrent as "bookFirstrent", | |
| book.book_totalrent as "bookTotalrent", | |
| book.book_totalday as "bookTotalday", | |
| book.book_state as "bookState", | |
| book_category.bookcategory_name as "bookcategory.bookcategoryName" | |
| FROM | |
| book, book_category | |
| Where | |
| book.bookcategory_no = book_category.bookcategory_no; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment