I have a Executesql calculation I am trying to make work and I am going in circles with it
I am currently using
ExecuteSQL ( " SELECT CTR_Warning_Type
WHERE Letter_AGE = 1 " ; "..." ; "" )
Which gives me a list of all "Warning Types" across all jobs that meet the Letter_Age = 1 requirement. I am performing this calculation in a job table, Field.
What I would like to realize is...
Only the "Warning Types" for that job (not all jobs) that meet the Letter_Age = 1 requirement.
What am I doing wrong? Should I not be using this via a Field Calculation?
Thanks in advance,