title: SQL Condition in a Conition
body: <p>im sorry that i cant google that questions, its mainly because i dont know the words for searching it up.</p>
  <p>Im still new to sql and i have to solve a problem - Lets say my table looks like this:</p>
  <pre><code>ID       DATUM       NAME
  1114     20200101    Heins
  1114     20190101    Heins
  1114     20200101    Norma
  1115     20200102    Dirk
  1111     20200102    Alex
  </code></pre>
  <p>I want to see every entry with the ID 1114 and the Date between 20200101 and 20200131.
  So my statement looks like this:</p>
  <pre><code>SELECT
          *
  FROM
          stackoverflowtable
          
  WHERE 
  DATUM BETWEEN '20200101' AND '202200131'
      AND ID = '1114' 
      OR ID = '1115'
  </code></pre>
  <p>This shows the correct date BUT ALSO every other date because of &quot;AND ID 1114&quot;</p>
  <p>So i need a way to say search IN THE RANGE OF THE DATE FOR ID.</p>
  <p>im sure its simple but i cant google it because lack of knowledge for the right words</p>