Field '<str>' (used in an OVER clause) is       defined in  more
  than two relations

  Explanation:  The OVER clause is  ambiguous  because  the  named
  field appears in more than two relations in the current query.

  User Action:  Use a WITH clause to express an unambiguous query.