diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-04-11 18:05:08 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-04-11 18:05:08 -0700 |
| commit | f4a34aeb6730e6a07ce1ca3562a1f2c704bb92bf (patch) | |
| tree | 93d07bcd9a69590fad141b4102b27418aa162bde | |
| parent | 2db41d569e9b1444ab41ce7ad5ee6b521b2e1231 (diff) | |
fix "add package columns" in customer report, RT#22525
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index fb516ee39..9de542cbc 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -814,7 +814,8 @@ sub search { if ($params->{'flattened_pkgs'}) { #my $pkg_join = ''; - $addl_from .= ' LEFT JOIN cust_pkg USING ( custnum ) '; + $addl_from .= + ' LEFT JOIN cust_pkg ON ( cust_main.custnum = cust_pkg.custnum ) '; if ($dbh->{Driver}->{Name} eq 'Pg') { |