title: SQL Server Full Outer Join Returning Rows with all NULL values
body: <p>When joining two tables using Full Outer Join, I am receiving results with NULL values in every column. The row count is the same as the count of the larger table. I would expect that at least one table columns would have values.
  Here is my simple select statement:</p>
  
  <pre><code>SELECT * FROM InputXML X 
  FULL OUTER JOIN ACM ON X.[file_name] = ACM.AllCharts
  </code></pre>