- SELECT
- RecipeID
- , IngredientID as ingre_id
- , ROUND(Quantity, 5) Quantity
- , Preparation
- , RecipeIngredientID
- , Validated
- , fd_Type
- , UnitOfUseID
- , OriginalQuantity
- , 2Preparation
- , CookingType
- , 2CookingType
- , PreviousIngredientID
- FROM recipeingredients
- where RecipeID =?
来源: http://www.bubuko.com/infodetail-2545975.html