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

[freeside.git] / httemplate / search / cust_credit.html

diff --git a/httemplate/search/cust_credit.html b/httemplate/search/cust_credit.html
index a3f88cc..85128bc 100755 (executable)
--- a/httemplate/search/cust_credit.html
+++ b/httemplate/search/cust_credit.html
@@ -41,14 +41,14 @@
                  : '';
 
    my $count_query = 'SELECT COUNT(*), SUM(amount) '.
-                     'FROM cust_credit JOIN cust_main USING ( custnum ) '.
+                     'FROM cust_credit LEFT JOIN cust_main USING ( custnum ) '.
                      $where;
 
    my $sql_query   = {
      'table'     => 'cust_credit',
      'hashref'   => {},
      'extra_sql' => $where,
-     'addl_from' => 'JOIN cust_main USING ( custnum )',
+     'addl_from' => 'LEFT JOIN cust_main USING ( custnum )',
    };
 
    my $clink = [ "${p}view/cust_main.cgi?", 'custnum' ];