title: MYSQL LEFT JOIN Multiple Tables Twice
body: <p>I have following MySQL Code:</p>
  
  <pre><code>SELECT * 
  FROM b_movies, b_mov_rol_celeb, b_starcast 
  LEFT JOIN bb_celebs ON b_mov_rol_celeb.celeb_id = bb_celebs.celeb_id 
    OR b_starcast.celeb_id = bb_celebs.celeb_id 
  LEFT JOIN bb_roles ON b_mov_rol_celeb.role_id = bb_roles.role_id 
  WHERE b_movies.id = '14';
  </code></pre>
  
  <p>Its giving error:</p>
  
  <blockquote>
    <p>Unknown column 'b_mov_rol_celeb.celeb_id' in 'on clause'</p>
  </blockquote>