title: FULL OUTER JOIN - mysql
body: <p>I have two tables, first table is called 'submissions' and the second table is called 'area'</p>
  
  <pre>
  ********  SUBMISSIONS TABLE  ********
  userid  statusid  no      name    area    month    year    dateupdated
  62      2         763     ABCD    Brazil      6    2013    2013-11-26 15:28
  62      1         869     ABC     Brazil      7    2012    2013-11-26 15:10
  62      2         869     ABC     Brazil      6    2013    2013-11-26 15:28
  62      1         869     ABC     Brazil      6    2013    2013-11-26 14:50
  61      1         763     ABCD    Brazil      6    2013    2013-11-26 14:50
  54      1         200     ABCDE   US         12    2013    2013-11-26 21:02
  32      2         200     ABCDE   US         12    2013    2013-11-26 21:03
  </pre>
  
  <pre>
  ******* AREA TABLE ********
    no      name    area     
    763     ABCD    Brazil  
    869     ABC     Brazil  
    869     ABC     Brazil  
    869     ABC     Brazil  
    763     ABCD    Brazil  
    200     ABCDE   US      
    200     ABCDE   US   
  </pre>
  
  <p>My Process:</p>
  
  <ul>
  <li>A user selects a status</li>
  <li>A user selects a month </li>
  <li>A user select a year</li>
  <li>All via dropdowns (SELECT)</li>
  </ul>
  
  <p>Once they have selected the 3 fields, the filtered data is displayed.</p>
  
  <p>What I am trying to achieve:</p>
  
  <p>I want the records to show as per the SELECTS Above (this works correctly at the moment)
  I also want to show all records from the 'Area' Table and where no data exists in the 'Submissions' table. An example of my desired output is below:</p>
  
  <pre>
  userid  statusid  no      name    area    month    year    dateupdated
  62      2         763     ABCD    Brazil      6    2013    2013-11-26 15:28
  62      1         869     ABC     Brazil      7    2012    2013-11-26 15:10
  62      2         869     ABC     Brazil      6    2013    2013-11-26 15:28
  62      1         869     ABC     Brazil      
                    763     ABCD    Brazil      
                    200     ABCDE   US        
                    200     ABCDE   US       
  </pre>
  
  <p>In Summary, I need to show the selected records as the SELECTS, but also need to display all records from the area table. </p>