我有这个查询:
SELECT DISTINCT CONCAT (MONTH(`Date`),'-',YEAR(`Date`))
from wp_result_plugin
WHERE Bet=2
AND month(`Date`) = EXTRACT(month FROM (NOW()))
ORDER BY MONTH(`Date`) ASC
UNION
SELECT DISTINCT CONCAT (MONTH(`Date`),'-',YEAR(`Date`))
from wp_result_plugin
WHERE Bet=2
AND month(`Date`)
ORDER BY MONTH(`Date`) ASC
我看到这个错误:
Incorrect usage of UNION and ORDER BY
如何使这项工作?