Selected Column "Does not exist" in WHERE statement.

Follow

Marianna Ripple

September 11, 2018 13:58

I don't have an issue with reading the highlighted field until I try to filter on its value... at which point, I receive an error message that the column does not exist.  Any help is appreciated.  See Image below.

0

• 

  Development September 11, 2018 14:02

  Hi Marianna - You need to use the long name for the field in that WHERE clause...

  per_att.section_count instead of count_of_absences

  A WHERE clause cannot use aliases from a SELECT clause if they are in the same scope.

  Jeff

  0

  Comment actions Permalink
• 

  Marianna Ripple September 11, 2018 14:04

  

  0

  Comment actions Permalink
• 

  Marianna Ripple September 11, 2018 14:05

  Thank you, Jeff!

  0

  Comment actions Permalink

Please sign in to leave a comment.