X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fbranches_db.inc;h=c02b74c2d8ad81747cbbd572c69a099555774e3b;hb=1e4cd218cd0b7e1093b4b63d6636f5360b3c7958;hp=2688d1b3e2d341e521db4deebfbfaeb753ec1121;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git

diff --git a/sales/includes/db/branches_db.inc b/sales/includes/db/branches_db.inc
index 2688d1b3..c02b74c2 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;
 }