title: MySQL Left Join (I think)
body: <p>i got into a problem. I have 3 tables, I join them but cant get the right answer, if anyone could help me, I would appreciate it. So what i want is, for Answer to show me unused Materials. Tables: <img src="https://i.stack.imgur.com/ot4e8.png" alt="enter image description here"></p>
  
  <p>With a lot of help I got all the unused materials with this: </p>
  
  <pre><code>SELECT DISTINCT(Materials.Material_Name) AS Unused_materials FROM Materials
  LEFT JOIN Table2 ON Table2.Material_Number = Materials.Material_Number
  LEFT JOIN Table1 ON Table1.Procedure_Name = Table2.Procedure_Name
  WHERE Table1.Procedure_Name IS NULL 
  </code></pre>
  
  <p><strong>UPDATED:</strong>
  If I may ask one more question in the same post. Maybe anyone would know how to get the above information, just with the Wanted Day. Like: Unused materials in 2012-11-20? </p>