title: Find missing ids between mysql tables
body: <p>When I run the following mysql statement, I get <strong>127 rows</strong> returned:</p>
  
  <pre><code>SELECT t.strat_id, t.candle_id, t.spot_entry, t.spot_close, t.f,t.fa,t.b,t.we,t.direct,t.date_created,t.date_closed,t.notes,t.results 
              FROM cp_user_trades AS t 
              INNER JOIN candles2 AS c 
                  ON t.candle_id = c.id 
              WHERE t.user_login = "user" 
              AND t.active=0 
              AND t.deleted=0 
              ORDER BY t.date_closed DESC
  </code></pre>
  
  <p>When I remove the <code>INNER JOIN</code> I get <strong>131 rows</strong> returned:</p>
  
  <pre><code>SELECT t.strat_id, t.candle_id, t.spot_entry, t.spot_close, t.f,t.fa,t.b,t.we,t.direct,t.date_created,t.date_closed,t.notes,t.results 
              FROM cp_user_trades AS t 
              WHERE t.user_login = "user" 
              AND t.active=0 
              AND t.deleted=0 
              ORDER BY t.date_closed DESC
  </code></pre>
  
  <p>How can I <code>SELECT</code> the <strong>4 rows</strong> that are not being returned in the first statement?</p>
  
  <p>Thank you!</p>