diff options
author | ivan <ivan> | 2009-11-13 07:12:35 +0000 |
---|---|---|
committer | ivan <ivan> | 2009-11-13 07:12:35 +0000 |
commit | 44d4252de771e6d41749363a61033452f1e97a15 (patch) | |
tree | 1920b766242f706015fcd4229efc95a8a20b4169 /FS/FS/cust_pkg.pm | |
parent | 121a0e466d425648801b687a474acb985090d1c6 (diff) |
fix advanced package report fallout from customer classes, RT#6677
Diffstat (limited to 'FS/FS/cust_pkg.pm')
-rw-r--r-- | FS/FS/cust_pkg.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm index e4846ec..fbd6a13 100644 --- a/FS/FS/cust_pkg.pm +++ b/FS/FS/cust_pkg.pm @@ -2593,7 +2593,7 @@ sub search_sql { my $addl_from = 'LEFT JOIN cust_main USING ( custnum ) '. 'LEFT JOIN part_pkg USING ( pkgpart ) '. - 'LEFT JOIN pkg_class USING ( classnum ) '; + 'LEFT JOIN pkg_class ON ( part_pkg.classnum = pkg_class.classnum ) '; my $count_query = "SELECT COUNT(*) FROM cust_pkg $addl_from $extra_sql"; |