title: Combining two tables and how to look for a record that contains two values from one table at least once
body: <p>Suppose there is a table for loans made in the library - (loan_no, member_no, book_no)
  and another table for a book (book_no, book_type, some other details)</p>
  <p>I want to select the records where one book from two different book categories were borrowed.</p>
  <p>For example, if loan_no includes one book each from book_type 'CRIME' and 'SCIENCE FICTION', I'd like to select it - and just that.
  How would I go about it?</p>
  <pre><code>SELECT  *
  FROM    loan
  JOIN    book
  ON      book.book_no = loan.book_no
  WHERE   &lt;loan_no contains book.book_category = 'SCIENCE FICTION' AND 'CRIME'&gt;
  </code></pre>
  <p>Thank you.</p>
  <p>CN</p>