Can I include an aggregate in a sql_on: clause?

0 0 38

Knowledge Drop

Last tested: Jul 1, 2020

Nope - in SQL order of operations, joins come before aggregation, therefore you can't have an aggregate in the sql_on: or any ON clause in a join.

This content is subject to limited support.