2024.06.24

2024.06.24 周一

菜品评价功能

针对已上架的菜品，需要从菜品评价表中获取菜品上架ID，再根据菜品上架ID，从菜品上架表中获取菜品ID，再从菜品表中获取菜品名字。

SELECT   
    s.ID AS ScoreID,
    s.MemberID,
    s.FoodGroundingID,
    f.FoodName,
    s.Satisfaction,
    s.DishEvaluation,
    s.UploadPic1,
    s.IsEnabled,
    s.CreateBy,
    s.CreateDate,
    s.ModifyBy,
    s.ModifyDate,
    s.Remarks
FROM   
    sc_food_score AS s  
JOIN   
    sc_food_grounding AS fg ON s.FoodGroundingID = fg.ID  
JOIN   
    sc_food AS f ON fg.FoodID = f.ID