I have a sql select statement that I must be doing something simple to mess up:
(simplified version of code....)

select *, iif("M"$pmdata.fterms,1,2) as fdatedue ;
from pmdata, inv_pend where fdatedue = 1

The message I get is "column fdatedue not found"

If I run without the where clause, I get the column, named and populated just how I want.

How do I reference a calculated column in a where clause?