title: joining two dataset to get optimal result
body: <p>Thanks in advance! this is little long question but hopefully it is clear and concise.</p>
  <p>I have two different query bringing two data sets.</p>
  <p>both datasets are bringing data in same grain for similar area.</p>
  <p><strong>first data set has multiple snapshots per month of a season , so it have three different metrics value for each season for same grain for a season.</strong></p>
  <p>Dataset 1 ( country , season , month , metric is column names )
  (1. A , autumn, 9/1, 1  is the record for column)</p>
  <p><strong>country</strong>       <strong>season</strong>     <strong>month</strong>        <strong>metric</strong></p>
  <ol>
  <li>A,              autumn ,     9/1 ,   1</li>
  <li>A,              autumn ,     10/1 ,   2</li>
  <li>A,              autumn ,     11/1 ,  3</li>
  </ol>
  <p><strong>where as the second data set has one snapshots (just one month out of season) for a season, so it will have just one snapshot per season.</strong></p>
  <p>Dataset 2</p>
  <p><strong>country</strong>            <strong>season</strong>         <strong>month</strong>            <strong>metric</strong></p>
  <ol>
  <li>A ,                    autumn ,           9/1   ,                4</li>
  </ol>
  <p><strong>my current approach  of full outer join is giving me the following output</strong></p>
  <p><strong>country</strong>                <strong>season</strong>       <strong>month</strong>       <strong>metric1</strong>      <strong>metric2</strong></p>
  <ol>
  <li><p>A,                     autumn,            9/1,               1,             4</p>
  </li>
  <li><p>A,                     autumn,            10/1,              2,</p>
  </li>
  <li><p>A,                     autumn ,           11/1,              3 ,</p>
  </li>
  </ol>
  <p>**<strong>Notice the metric2 for 10/1 and 11/1 are blank or zero if use nvl but what we need is to populate
  same value 4 for these two months as well</strong> <strong>how can we achieve this</strong></p>
  <p><strong>or FINAL OUTPUT should look something like this</strong></p>
  <p><strong>country</strong>                <strong>season</strong>       <strong>month</strong>       <strong>metric1</strong>      <strong>metric2</strong></p>
  <ol>
  <li><p>A,                     autumn,            9/1,               1,             4</p>
  </li>
  <li><p>A,                     autumn,            10/1,              2,             4</p>
  </li>
  <li><p>A,                     autumn ,           11/1,              3 ,            4</p>
  </li>
  </ol>