临时更改SQL数据

Question

我想知道是否可以暂时更改SQL中的数据。

我有三个月的时间做七月、八月和九月的工作。我想将它们分别改为1、2和3，以便我可以做到以下几点：

SELECT * FROM
(
(SELECT aID, month AS monthA FROM tblA) AS a
INNER JOIN
(SELECT bID, month AS monthB FROM tblB) AS b
ON a.ID = b.ID
)
WHERE a.month < b.month

我知道这很管用

SELECT * FROM
    (
    (SELECT aID, month AS monthA FROM tblA) AS a
    INNER JOIN
    (SELECT bID, month AS monthB FROM tblB) AS b
    ON a.ID = b.ID
    )
    WHERE (a.month = 'July' AND b.month = 'August')

Answer 1

听起来你只是想把varchar数据转换为1,2,3，而不一定要在数据库中更改它，对吗？

为什么不做一个案例stmt，将值更改为1,2,3，然后做您需要做的事情。

 SELECT * FROM
(
(SELECT aID, CASE month WHEN 'July' THEN '1' WHEN 'August' THEN '2' WHEN 'September' THEN '3' ELSE month END AS monthA FROM tblA) AS a
INNER JOIN
(SELECT bID, CASE month WHEN 'July' THEN '1' WHEN 'August' THEN '2' WHEN 'September' THEN '3' ELSE month END AS monthB FROM tblB) AS b
ON a.aID = b.bID
)
WHERE a.monthA < b.monthB