summaryrefslogtreecommitdiff
path: root/FS
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2021-04-21 11:30:53 -0700
committerIvan Kohler <ivan@freeside.biz>2021-04-21 11:30:53 -0700
commit61344de2708cefb228f6e8c03a25935e3dd497d3 (patch)
treeb08fdea1da3334925654aec875b9224c2bbbf736 /FS
parente1397c2e42682e73861ea3cb940876c309db3399 (diff)
eliminate dups, RT#85671
Diffstat (limited to 'FS')
-rw-r--r--FS/FS/Report/FCC_477.pm2
1 files changed, 1 insertions, 1 deletions
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