title: Oracle - Check if there is a data in range of date
body: <p>I have three tables (receipts, receiptaddinfo, shops). I have select, that gives me a data with a all receipts from all shops since the declared date:</p>
  
  <pre><code>select *
  from receipts r
  join receipt receiptaddinfo ri on r.receiptid=ri.receiptid and r.shop=ri.shop
  join shops s on ri.shop=s.shop and shoptype=0
  where ri.creationtime &gt;= '2016-05-19 00:00:00' 
  order by ri.creationtime desc
  </code></pre>
  
  <p>The table shops, contain all shops, however, I want to check if there is a shop, which had no 'sale/receipts' since the declared date. Could somebody help? </p>