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!

Reply