title: Mysql - Finding a record that satisfies 2 exact dates
body: <p>Fairly new to mysql &amp; the stack overflow community. - I have a question that's been bugging me. </p>
  
  <p>I'm trying to return the results of individuals that have taken out a book on 2 specific dates. This is my effort so far;</p>
  
  <pre><code>SELECT borrower.fname, borrower.lname
  FROM borrower, loan
  WHERE borrower.cardno = loan.cardno
  AND loan.dateout = DATE '2019-01-01'
  AND loan.dateout = DATE '2018-02-01';
  </code></pre>
  
  <p>I'm not sure why I'm not getting any results - When I run the query with just one date it comes up with results. I can see from these results that there are definitely records that should satisfy the criteria, I'm not sure where I'm going wrong. </p>
  
  <p>Can anyone pinpoint where I'm going wrong? I thought it looked quite straightforward but it's driving me crazy.</p>
  
  <p>Thanks</p>