mysql - 这个 SQL 查询有什么问题

Question

这个查询给我错误，请问这个查询有什么问题？

SELECT recipes.recipeId as recipeId,
       recipes.title as title, 
       recipes.cookingtime as cookingtime, 
       recipes.serving as serving, 
       schedule.catId as catId, 
       images.imagePath AS imagePath 
  FROM recipes 
 INNER JOIN schedule ON recipes.recipeId = schedule.recipeId 
 INNER JOIN images   ON images.recipeId = recipes.recipeId 
 GROUP BY recipeId
 WHERE schedule.day = 'saturday'  
 ORDER BY catId ASC

我觉得查询中group by的位置不对。

Answer 1

你的想法是正确的。 GROUP BY 应该在 WHERE 子句之后和 ORDER BY 子句之前。

SELECT recipes.recipeId as recipeId,
       recipes.title as title, 
       recipes.cookingtime as cookingtime, 
       recipes.serving as serving, 
       schedule.catId as catId, 
       images.imagePath AS imagePath 
  FROM recipes 
 INNER JOIN schedule ON recipes.recipeId = schedule.recipeId 
 INNER JOIN images   ON images.recipeId = recipes.recipeId 
 WHERE schedule.day = 'saturday'  
 GROUP BY recipeId
 ORDER BY catId ASC