MS-SQL Server
请问这两句联合查询如何写？
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区有两个表，一个销售表data_saledata，另外一个采购表data_buy
这句是按月查出每个月销售总金额并按年月排序：
SELECT DatePart('yyyy',saledate) AS colyear, DatePart('m',saledate) AS colmonth, sum(lastamount) AS saleamount
FROM data_saledata
GROUP BY DatePart('yyyy',saledate), DatePart('m',saledate)
ORDER BY DatePart('yyyy',saledate) DESC , DatePart('m',saledate);
以下这句是按月查出每个月采购总金额并按年月排序：
SELECT DatePart('yyyy',purchasedate) AS colyear, DatePart('m',purchasedate) AS colmonth, sum(amount) AS purchaseamount
FROM data_buy
GROUP BY DatePart('yyyy',purchasedate), DatePart('m',purchasedate)
ORDER BY DatePart('yyyy',purchasedate) DESC , DatePart('m',purchasedate);
我现在想把两个查询的结果显示在一起,并按年月排序，请问SQL命令如何写，谢谢
这句是按月查出每个月销售总金额并按年月排序：
SELECT DatePart('yyyy',saledate) AS colyear, DatePart('m',saledate) AS colmonth, sum(lastamount) AS saleamount
FROM data_saledata
GROUP BY DatePart('yyyy',saledate), DatePart('m',saledate)
ORDER BY DatePart('yyyy',saledate) DESC , DatePart('m',saledate);
以下这句是按月查出每个月采购总金额并按年月排序：
SELECT DatePart('yyyy',purchasedate) AS colyear, DatePart('m',purchasedate) AS colmonth, sum(amount) AS purchaseamount
FROM data_buy
GROUP BY DatePart('yyyy',purchasedate), DatePart('m',purchasedate)
ORDER BY DatePart('yyyy',purchasedate) DESC , DatePart('m',purchasedate);
我现在想把两个查询的结果显示在一起,并按年月排序，请问SQL命令如何写，谢谢
...全文
