diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2021-04-21 11:30:56 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2021-04-21 11:30:56 -0700 |
| commit | 04d613ce3a2f51e90e4a103e28ce0e0858e8169e (patch) | |
| tree | 36d22f9126786ef55ce3dc6396aad943822a4882 | |
| parent | e72a34d0f1719ed3e96f0c1f18bb9f4811239245 (diff) | |
eliminate dups, RT#85671
| -rw-r--r-- | FS/FS/Report/FCC_477.pm | 2 |
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 |