eliminate dups, RT#85671

diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm
index bb01db4..760f6f2 100644 (file)
--- 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';
 
 
   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
   FROM $from
   WHERE ".join(' AND ', @where)."
   ORDER BY $order_by