2024.06.24

marverdol發表於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

相關文章