Skip to content

Instantly share code, notes, and snippets.

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

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

Select an option

Save enujo/ccfbd7e8ca11f01b277fcff847f7a6b0 to your computer and use it in GitHub Desktop.
erro selectquery
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