MYSQL 如何在连接表中进行排序

Question

我有这个 SQL 正在运行，但它没有像我想要的那样按 DESC 排序。它完全忽略了命令的顺序。

这是sql

SELECT Sales.saleId, Sales.tax, Sales.subtotal, Sales.total, Sales.created as createdTemp, Users.firstName, Users.lastName
            FROM Sales
            JOIN Users
            ON Sales.userId = Users.userId
            JOIN Companies
            ON Companies.companyId = 1
            ORDER BY Sales.saleId DESC

Answer 1

试试这个:

SELECT * FROM
(
  SELECT Sales.saleId, Sales.tax, Sales.subtotal, 
         Sales.total, Sales.created as createdTemp,
         Users.firstName, Users.lastName
            FROM Sales
            JOIN Users
            ON Sales.userId = Users.userId
            JOIN Companies
            ON Companies.companyId = 1
) AS s
ORDER BY s.saleId DESC;