title: What kind of join to use on SQL tables
body: <p>I have 3 tables that contain data on movies. They are called appalling, average and outstanding. They all have columns title_types, genre, year and rating. I am trying to join all 3 tables into a new table called facts, using this hint:</p>
  
  <p>Think carefully about the join types for this
  query to avoid losing records from the individual tables. </p>
  
  <p>My initial thought is to join all tables using a full outer join, and doing some digging, this was my code</p>
  
  <pre><code>CREATE TABLE Facts as 
  SELECT Appalling.title_type, Average.title_type, Outstanding.title_type
  FROM Appalling 
  FULL OUTER JOIN Average ON Appalling.title_type = Average.title_type
  FULL OUTER JOIN Outstanding ON Appalling.title_type = Outstanding.title_type;
  </code></pre>
  
  <p>However I am not sure if this is the smartest way to join all tables. Any help is appreciated. I believe the final output should look like such:</p>
  
  <pre><code>title_type | genre  | year | appalling | average | outstanding
  movie        drama    1992    1            NULL      NULL
  tv           comedy   2001    NULL          15       NULL
  short        drama    2014    NULL         NULL      17
  </code></pre>