AnsweredAssumed Answered

ExecuteSql Command

Question asked by Jason_Farnsworth on Mar 2, 2015
Latest reply on Mar 2, 2015 by BruceHerbach

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

FROM JOB_SES

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,

 

Jason Farnsworth

Outcomes