Alias <str> not used by this query

  Explanation:  You used an authorization identifier to qualify a
  reference to a column and that authorization identifier was not
  specified in the FROM clause of the query.

  User Action:  Either remove the authorization identifier that
  qualifies the select-list item or specify the same authorization
  identifier as specified in the FROM clause of the query.