MYSQL组合 View 在日期范围内具有不同数量的条目记录的两个表

Question

引用我之前的question ，我前几天问过并得到了解决方案。答案非常好..但现在的问题是当我给我的表记录提供范围时..它并没有达到我想要的结果。 IE。

上图是查询结果:

SELECT Sale.Date AS Date, Sale.Description AS SaleDescription, "" AS   ExpenseDescription, Sale.Amount AS SaleAmount, "" AS ExpenseAmount
FROM Sale
WHERE Sale.Date >= '2014-09-01'
UNION ALL
SELECT Expense.Date AS Date, "" AS SaleDescription, Expense.Description AS ExpenseDescription, "" AS SaleAmount, Expense.Amount AS ExpenseAmount
FROM Expense
WHERE Expense.Date >= '2014-09-01'

当你查看我之前的question时在其中针对特定日期运行查询..给出了正确的结果..(正确的结果)..但是当我给它一个日期范围时，它显示记录而不是按日期排序。就像这里

它显示某个日期范围内一个表中的所有记录。然后显示日期范围内的第二个表记录。

我希望它应该按日期显示记录，但不按表格显示。!

我希望你能理解我的问题，因为我的英语不太好。

提前致谢

Answer 1

就像 Tim B 所说的那样，嵌套解决方案应该如下所示:

SELECT * FROM
  (SELECT Sale.Date AS Date, Sale.Description AS SaleDescription, "" AS   ExpenseDescription, Sale.Amount AS SaleAmount, "" AS ExpenseAmount
   FROM Sale
   WHERE Sale.Date >= '2014-09-01'
   UNION ALL
   SELECT Expense.Date AS Date, "" AS SaleDescription, Expense.Description AS ExpenseDescription, "" AS SaleAmount, Expense.Amount AS ExpenseAmount
   FROM Expense
   WHERE Expense.Date >= '2014-09-01') AS SaleExpense
ORDER BY
  SaleExpense.Date ASC