Selected Column "Does not exist" in WHERE statement.

Comments

3 comments

  • Avatar
    Development

    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
  • Avatar
    Marianna Ripple

    0
    Comment actions Permalink
  • Avatar
    Marianna Ripple

    Thank you, Jeff!

    0
    Comment actions Permalink

Please sign in to leave a comment.