diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-04-11 18:05:07 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-04-11 18:05:07 -0700 |
| commit | 194d0e29f4587669032da09c3bf814c3531898a2 (patch) | |
| tree | afe30c352efbd930f405276d2bc751479488b3a4 | |
| parent | 194da40d2ffbaa8a2604c75a74b650a730c3a000 (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 d8f620f..9ec40cd 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -857,7 +857,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') { |