title: FULL JOIN query results in Error Code: 1054. Any workaround?
body: <p>I'm trying to join two tables to show all rows that match the where clause, not just the ones that match the join. It's two tables of bills and I am trying to merge them so that each row with matching year and month from both tables has a few fields from each.</p>
  <pre><code>SELECT
      tblhydrobill.billyear, tblhydrobill.billmonth, tblhydrobill.KWH as elecconsumption, tblhydrobill.CurrentCharges as eleccost,
      tblgasdata.cubicft as gasconsumption, tblgasdata.total as gascost
  FROM tblhydrobill
  FULL JOIN tblgasdata ON tblhydrobill.billyear = tblgasdata.billyear and tblhydrobill.billmonth = tblgasdata.billmonth
  WHERE tblhydrobill.meteridnumber = 19 and tblgasdata.buildingid = 19
  ORDER BY tblhydrobill.billyear asc, tblhydrobill.billmonth asc
  </code></pre>
  <p>LEFT JOIN executes properly, but only shows results where data exists for month/year on both tables. I am trying to get it to return all rows, it's ok if there are null fields on one side of the join if there is no match on the other side and vice-versa.</p>
  <p>Using FULL JOIN I get the following MySQL error:</p>
  <pre class="lang-none prettyprint-override"><code>Error Code: 1054. Unknown column 'tblhydrobill.billyear' in 'field list'
  </code></pre>
  <p>Update:</p>
  <p>FULL JOIN is not supported yet by MySQL as pointed out by @jarlh, thanks.</p>