In my query, I use a function IIFto assign "Before" or "After" to a field named BeforeOrAfterwith AS.
However, when I run this query, the Enter Parameter Value dialog box appears asking for a value for BeforeOrAfter. If I remove BeforeOrAfter DESCfrom the sentence ORDER BY, I will not get a dialog.
Here is an abusive request:
SELECT
d.Scenario,
e.Event,
IIF(d.LogTime < e.Time, 'Before','After') AS BeforeOrAfter,
d.HeartRate
FROM
Data d INNER JOIN
Events e ON d.Scenario = e.Scenario
WHERE
e.Include = Yes
ORDER BY
d.Scenario,
e.Id,
BeforeOrAfter DESC
Question: Why is mine AS BeforeOrAfternot recognized by the sentence ORDER BY? Why is he asking me to enter a parameter value for "BeforeOrAfter" when running this query?
. , , .., .