APIv4 - Simplify bridge joins
authorColeman Watts <coleman@civicrm.org>
Sun, 30 Apr 2023 22:06:32 +0000 (18:06 -0400)
committerColeman Watts <coleman@civicrm.org>
Sun, 30 Apr 2023 22:06:32 +0000 (18:06 -0400)
commitd11f6e17002accd2f34d679b7faed2097060aa18
tree989424ab2684ca7bd67704b2b9e0121c4065ee76
parent5b4708ffff1ef0cf46bed373b10e3ba593b03271
APIv4 - Simplify bridge joins

This simplifies the code and improves efficiency by using an inner sub-join
instead of a subquery. The latter was trying to fake it, but this is the real
thing: joining on two tables as if they were a single table.
Civi/Api4/Query/Api4SelectQuery.php