* is not allowed in this context

  Explanation:  You specified a column wildcard (* or p.*) in a
  context where wildcards are not supported, such as outside a
  select list or in a select list for a select expression
  containing a HAVING clause but no GROUP BY (in such a case, you
  cannot specify columns, either, unless they are an argument to
  an aggregate function).

  User Action:  Replace the wildcard with the column name you want
  to use.