I am creating a table and in the select I am creating a SUM(PO.SvcFrom2 - FO.SvcFrom) AS “Days Diff”
Then in my WHERE clause I am trying to use that field for example:
WHERE “Days Diff” > 0
But I am getting DB Error: “Improper use of an aggregate function in a WHERE Clause.”
Is there some way around this or do I need to create another table that is subset using this where clause?