php - 使用 LIMIT 选择左连接

Question

我在限制 Jokes 表的行数时遇到问题。

这是我的查询工作，获取所有行:

SELECT Jokes.ID, Categories.CategoryName, Jokes.CategoryID, Jokes.JokeText 
FROM Jokes 
LEFT JOIN Categories 
ON Jokes.CategoryID = Categories.ID 
ORDER BY Jokes.ID DESC

会是这样吗？

SELECT Jokes.ID, Categories.CategoryName, Jokes.CategoryID, Jokes.JokeText 
FROM (
SELECT * FROM Jokes ORDER BY ID DESC Limit 0,40) 
AS a 
LEFT JOIN Categories 
AS b 
ON a.CategoryID = b.ID

Answer 1

为什么不使用

SELECT Jokes.ID, Categories.CategoryName, Jokes.CategoryID, Jokes.JokeText 
FROM Jokes 
LEFT JOIN Categories 
ON Jokes.CategoryID = Categories.ID 
ORDER BY Jokes.ID DESC
Limit 0,40