Commented by: @aafemt

Subquery is inside of aggregation function so there is no problem with it.

Tracker is not a support list.

Commented by: Attila Molnár (e_pluribus_unum)

I understand, this

SELECT
e.emp_no
FROM employee e
JOIN employee_project p ON p.emp_no = e.emp_no
GROUP BY e.emp_no
HAVING (SELECT
SUM(e2.salary)
FROM employee e2
JOIN employee_project p2 ON p2.emp_no = e2.emp_no
WHERE e2.emp_no = e.emp_no AND
p2.proj_id IS NOT DISTINCT FROM MAX(p.proj_id)) <> 0

but in the original case the aggregate was on the result of the subselect. To get the resultset what p.proj_id used in the original case?

(BTW the yahoo support group is not so alive. I reported CORE6151 there a weak before here, but still no answen on that forum. At leas this tracker is resposive.
Is there an alernative support list?)

Commented by: Sean Leyne (seanleyne)

As Dmitry noted:

- The SQL is valid
- This is not a support list.