title: mysql select having multiple n to n's
body: <p>I have tables resembling this</p>
  
  <pre><code>recipes_tbl
  | id | Recipe | Directions |
  
  ingredients_tbl
  | id | Ingrediant | Category |
  
  recipe_to_ingredient
  | id | id_recipe  | id_ingredient | Quantity
  </code></pre>
  
  <p>I'm trying to build a query to "Get all recipes that use beef(id_ingredient 1) and potatoes(id_ingredient 2) and ...n"</p>
  
  <p>I suspect the solutios involves some kind of fancy joins... maybe?</p>