title: How to combine 4 columns from 2 Access queries into 3 columns of single query?
body: <p>This question is similar to the one here <a href="https://stackoverflow.com/questions/5846064/sql-union-query-with-extra-field-in-results">stackoverflow</a> however it does differ.</p>
  <p>I am trying to combine two different queries into one query. Each query has 2 columns. Here is some sample data.</p>
  <pre><code>Query #1
  Country | Quantity
  USA     | 312
  Canada  | 513
  Mexico  | 258
  
  Query #2
  Country | Quanity
  USA     | 425
  UK      | 394
  Mexico  | 489
  </code></pre>
  <p>And then the final query needs to look like this...</p>
  <pre><code>Country | Query#1 | Query #2
  USA     | 312     | 425
  Canada  | 513     | 0
  UK      | 0       | 394
  Mexico  | 258     | 489
  </code></pre>
  <p>The empty ones can be blank, or 0 it does not matter.</p>
  <p>It seems like I need to use a FULL OUTER JOIN, or something to that affect, but Access does not have a FULL OUTER JOIN.</p>
  <p>I have tried to use a union query, but I do not understand them well enough to accomplish this. Any help is much appreciated!</p>