March 17th, 2013, 03:56 PM
Hi, I am using Sqlite, and I have two databases, one named Books, the other named BooksCategories,
Can someone please help me with the code to return the Title and CategoryID of each book from the Books and BookCategories tables?
March 17th, 2013, 04:03 PM
ON bookscategories.bookid = books.id
March 17th, 2013, 06:23 PM
Hi, if I have the tables Books, Publisher, and BookCategories,
can you join together the Books, Publisher and BookCategories tables using UNION? Assuming we only want to return the PublisherID and CategoryID fields from the latter two tables.
March 17th, 2013, 11:50 PM
Originally Posted by nav505
use JOIN, like in the example i gave you for your first question above