title: SQL - How to combine 3 dates from 3 different tables (BigQuery)
body: <p>Need to have one view for each agent, and want to aggregate all dates to include all metrics</p>
  <p><strong>Basic Information:-</strong></p>
  <ul>
  <li><p>In the <strong>productivity</strong> table carries the information like as follows:</p>
  <pre><code>  | Handled_DATE   | Agent_Email           | Handled  | Missed
    |:-----------:  |:-------------:         |:--------:|:------:|
    |2013-11-05     |  Agent_01@google.com   |    80    |    9
    |2013-11-06     |   Agent_02@google.com  |    60    |   15
    |2013-11-07     |   Agent_03@google.com  |    70    |    7
    |2013-11-08     |   Agent_04@google.com  |    55    |   13
    |2013-11-09     |   Agent_01@google.com  |    73    |    5
    |2013-11-10     |   Agent_01@google.com  |    64    |   14
  </code></pre>
  </li>
  <li><p>In the <strong>Quality</strong> table carries the information like this:</p>
  <pre><code>  | Monitored_DATE  | Agent_Email          | Bussiness_Critical | Failed
    |:-----------:  |:-------------:         |:-------------:     |:-----------:|
    |2013-11-05     |  Agent_01@google.com   |    2               |    2
    |2013-11-06     |   Agent_01@google.com  |    1               |    1
    |2013-11-07     |   Agent_01@google.com  |    4               |    4
    |2013-11-08     |   Agent_04@google.com  |    1               |    1
  </code></pre>
  </li>
  </ul>
  <p>In the <strong>Absentieesm</strong> table it carries the information like this:</p>
  <pre><code>| Attendance_Date | Agent_Email           | Attendance | Late_min
  |:-----------:    |:-------------:        |:----------:|:-----------:|
  |2013-11-05       |  Agent_01@google.com  |    Attend  |    9
  |2013-11-06       |  Agent_01@google.com  |    Sick    |    0
  |2013-11-07       |  Agent_01@google.com  |    Sick    |    0
  |2013-11-08       |  Agent_04@google.com  |    55      |   13
  |2013-11-10       |  Agent_01@google.com  |    Attend  |    0
  </code></pre>
  <p><strong>Desired Output</strong></p>
  <pre><code>| DATE       | Agent_Email           | Handled | Missed | Business_Critical | Failed |Attendance|Late_min
  |:---------- |:-------------:        |:-------:|:------:|:-----------------:|:-----: |:--------:|:------:|
  |2013-11-05  |  Agent_01@google.com  |    80   |    9   |       2           |   2    |  Attend  |   9
  |2013-11-06  |  Agent_01@google.com  |    0    |    0   |       1           |   1    |  sick    |   0
  |2013-11-07  |  Agent_01@google.com  |    0    |    0   |       4           |   4    |  sick    |   0
  |2013-11-08  |  Agent_01@google.com  |    0    |    0   |       0           |   0    |  sick    |   0
  |2013-11-09  |  Agent_01@google.com  |    73   |    5   |       0           |   0    |  NA      |   0
  |2013-11-10  |  Agent_01@google.com  |    64   |   14   |       0           |   0    |  Attend  |   0
  </code></pre>