From b0888dc8399fc4e8d75c874c00d01366eacf5596 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Wed, 21 Apr 2021 11:30:50 -0700 Subject: [PATCH] eliminate dups, RT#85671 --- FS/FS/Report/FCC_477.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm index bb01db4c8..760f6f22d 100644 --- a/FS/FS/Report/FCC_477.pm +++ b/FS/FS/Report/FCC_477.pm @@ -384,7 +384,7 @@ sub fbd_sql { my $order_by = 'censusblock, agentnum, technology, is_consumer, is_business'; - "SELECT ".join(', ', @select) . " + "SELECT DISTINCT ".join(', ', @select) . " FROM $from WHERE ".join(' AND ', @where)." ORDER BY $order_by -- 2.11.0