Skip to content

Instantly share code, notes, and snippets.

@enujo
Created February 3, 2017 05:49
Show Gist options
  • Select an option

  • Save enujo/fcbc52fc300bbf1944d0e3b0e63331fe to your computer and use it in GitHub Desktop.

Select an option

Save enujo/fcbc52fc300bbf1944d0e3b0e63331fe to your computer and use it in GitHub Desktop.
select sqlquery
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