Can't have aggregate function in JOIN operation (Item).

Error 3099

You can't use an aggregate function in the JOIN operation of an SQL statement29F05E5.

See Also

LEFT JOIN, RIGHT JOIN Operations (SQL)AKPI8QA

SQL Aggregate FunctionsM7QTSY