From 567197b13b8979c50c4d2fac3499863abfd0c3a8 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 15 May 2011 20:34:27 +0200 Subject: [PATCH] [0000806] Branches were repeated in Customer Branches table when more than one general contact defined. --- sales/includes/db/branches_db.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sales/includes/db/branches_db.inc b/sales/includes/db/branches_db.inc index 2688d1b..c02b74c 100644 --- a/sales/includes/db/branches_db.inc +++ b/sales/includes/db/branches_db.inc @@ -164,7 +164,7 @@ function get_sql_for_customer_branches() AND b.debtor_no = ".db_escape($_POST['customer_id']); if (!get_post('show_inactive')) $sql .= " AND !b.inactive"; - $sql .= " ORDER BY branch_ref"; + $sql .= " GROUP BY b.branch_code ORDER BY branch_ref"; return $sql; } -- 2.30.2