report correctly even if the customer record has somehow been removed...

[freeside.git] / httemplate / search / cust_pay.cgi

diff --git a/httemplate/search/cust_pay.cgi b/httemplate/search/cust_pay.cgi
index 42b3c01..64fe1f9 100755 (executable)
--- a/httemplate/search/cust_pay.cgi
+++ b/httemplate/search/cust_pay.cgi
@@ -68,7 +68,7 @@
 
      my $hsearch = join(' AND ', map { "$_ = '$search{$_}'" } keys %search );
      $count_query = "SELECT COUNT(*), SUM(paid) ".
-                    "FROM cust_pay JOIN cust_main USING ( custnum )".
+                    "FROM cust_pay LEFT JOIN cust_main USING ( custnum )".
                     ( $hsearch ? " WHERE $hsearch " : '' ).
                     $search;
    
@@ -77,7 +77,7 @@
        'table'     => 'cust_pay',
        'hashref'   => \%search,
        'extra_sql' => "$search ORDER BY _date",
-       'addl_from' => 'JOIN cust_main USING ( custnum )',
+       'addl_from' => 'LEFT JOIN cust_main USING ( custnum )',
      };
    
    } else {