title: How to set up independent queries within a single query
body: <p>I need to query a table for null values but on different fields. I have been setting up my queries independently and running them one at a time to view my results. </p>
  
  <p>EX:</p>
  
  <p>Query 1:</p>
  
  <pre><code>select * from TABLE1 where FIELD1 is null and FIELD2 is NOT null
  </code></pre>
  
  <p>Query 2:</p>
  
  <pre><code>Select * from TABLE1 where FIELD6 = 'YES' and FIELD2 is null
  </code></pre>
  
  <p>Query 3:</p>
  
  <pre><code>select * from TABLE1 where FIELD4 = 'OUTSIDE' and FIELD7 is not null
  </code></pre>
  
  <p>Is there a way to set up a single query which will allow me retrieve data from a single table but run queries where the conditions are different? </p>