title: SQL - Get data for yesterday and day before
body: <p>I am running this query:    </p>
  
  <pre><code>select member, customerinfo.customerid -- ...other irrelevant columns...
  from customerinfo, addressinfo
      where customerinfo.customerid = addressinfo.customerid
      and MEMBER = (Date(GetDate()-1))
      and addressinfo.addresstype = 's'
  </code></pre>
  
  <p>I it is obviously giving me data if Member = yesterday.</p>
  
  <p>My question is, how do I structure the query to give me data if Member = the last 2 days (yesterday and the day before)?</p>