Knowledge Drop

Can I include an aggregate in a sql_on: clause?

Userlevel 4

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.                



0 replies

Be the first to reply!