I would like to know if it is possible change the data in SQL temporarily
I have three months as varchar July, August, and September. I would like to change them to 1, 2, and 3 respectively so that I can do the following:
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
I know this works
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')
See Question&Answers more detail:os