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?
Steve Howie, owner
DaSH Technology
Denver, CO