用SQL Server处理物料清单规则

SELECT 
      IngredientsRequired_by_Recipe_qs.RecipeID, 
      Recipes.RecipeName
FROM 
      (IngredientsAvailable_By_Recipe_qs 
      INNER JOIN IngredientsRequired_by_Recipe_qs 
      ON IngredientsAvailable_By_Recipe_qs.RecipeID = IngredientsRequired_by_Recipe_qs.RecipeID) 
      INNER JOIN Recipes 
      ON IngredientsRequired_by_Recipe_qs.RecipeID = Recipes.RecipeID
WHERE (([Available]>=[Required]));