title: MYSQL LEFT JOIN select enhance
body: <p>I am doing a select with left join just wondering if i am doing it correctly.</p>
  
  <p>I am got two tables a job table and a job assign table, i would like to select job creator and also job who have been assigned as well. the following code i have used 1 for id.</p>
  
  <pre><code>    JOB Table
  ++++++++++
      id
      user_id (capture creator id)
      title
  
      JOB ASSIGN TABLE
  ++++++++++
      id
      job_id 
      user_id (capture assign id)
  </code></pre>
  
  <p>========</p>
  
  <pre><code>SELECT
      a.id,
      a.title
  FROM
      job a
  LFET JOIN job_assign b
  ON
      a.id = b.job_id 
  WHERE
  (
      a.user_id = 1
          OR
      b.user_id =1
  )
  </code></pre>
  
  <p>The above query works but its a bit slow, and when i check Explain</p>
  
  <pre><code>1
  SIMPLE
  b
  ALL
  NULL
  NULL
  NULL
  NULL
  358
  Using where; Using temporary; Using filesort
  </code></pre>
  
  <p>is there anyway to enhance my query, would be a good lesson for me :)</p>