title: mySQL outer join
body: <p>I have 2 tables for which I need to run a query on</p>
  <blockquote>
  <p>Table1 has 2 fields: l_id, and name</p>
  <p>Table2 also has 2 fields:   l_id, and b_id</p>
  </blockquote>
  <p>I need to run a query to get the &quot;name&quot; and &quot;l_id&quot; for all the entries in table1 that do not have an entry in table2 for a given b_id.</p>
  <p>Hope this makes some sense</p>