Full outer Join mySQL - missing rows
<p>I am trying to emulate a full outer join in mySQL by using a left join and unioning it with a right join.</p>

<pre><code>SELECT * FROM auxview_candiNotes AS a
LEFT JOIN auxview_clientNotes AS b ON a.dateAdded = b.dateAdded
UNION
SELECT * FROM auxview_candiNotes AS a
RIGHT JOIN auxview_clientNotes AS b ON a.dateAdded = b.dateAdded
</code></pre>

<p>The reason I am doing this is because I am joining two tables and occasionally one of them will not have a value on a specific date (thus the date is not listed in the table). However the joined table should display all dates, that occur in either or both of the tables. If one of the tables does not contain a value for a specific date, it should return NULL.</p>

<p>However, some dates from the auxview_clientNotes table are not listed in the joined table.</p>

<p>Thanks in advance!</p>