title: SQL Date Filter on Two Fields
body: <p>I am trying to query a table that has a date field (in <code>YYYYMM</code>) and two sales forecasts fields, but I want to query it in a way where I can query two different date ranges on separate columns but include them in the same output</p>
  <p>The table is called SalesTable</p>
  <p>Column Names are <code>CCYYMM</code> (date field), <code>FORECAST 1</code> (numbers), <code>FORECAST 2</code> (numbers)</p>
  <p>Date Field Ranges from <code>201801</code> to <code>202412</code></p>
  <p>I want to create a query to get all sales values from <code>FORECAST 1</code> from <code>201801</code> to <code>202006</code> and all sales values for <code>FORECAST 2</code> from <code>202008</code> to <code>202112</code>, is this possible to do in a single query?</p>