"""Guard: no subquery predicate inside a JOIN's ON clause that Databricks rejects at query time. Why: Databricks rejects a correlated subquery in a join predicate that references both join inputs ...