From 8db462f570d91f1064fc2fa5f746ccd33bafdc95 Mon Sep 17 00:00:00 2001
From: Coleman Watts <coleman@civicrm.org>
Date: Thu, 11 Nov 2021 21:42:36 -0500
Subject: [PATCH] APIv4 - Add backticks around fields in join criteria

Fixes dev/mail#103
---
 Civi/Api4/Service/Schema/Joinable/Joinable.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Civi/Api4/Service/Schema/Joinable/Joinable.php b/Civi/Api4/Service/Schema/Joinable/Joinable.php
index 2681466d86..6b5aed9e82 100644
--- a/Civi/Api4/Service/Schema/Joinable/Joinable.php
+++ b/Civi/Api4/Service/Schema/Joinable/Joinable.php
@@ -104,7 +104,7 @@ class Joinable {
    */
   public function getConditionsForJoin(string $baseTableAlias, string $tableAlias) {
     $baseCondition = sprintf(
-      '%s.%s =  %s.%s',
+      '`%s`.`%s` =  `%s`.`%s`',
       $baseTableAlias,
       $this->baseColumn,
       $tableAlias,
-- 
2.25.1