diff options
| -rwxr-xr-x | httemplate/search/report_tax.cgi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi index f37e1275d..8b1c095b6 100755 --- a/httemplate/search/report_tax.cgi +++ b/httemplate/search/report_tax.cgi @@ -44,8 +44,8 @@ foreach my $r ( FROM cust_bill_pkg JOIN cust_bill USING ( invnum ) JOIN cust_main USING ( custnum ) - JOIN cust_pkg USING ( pkgnum ) - JOIN part_pkg USING ( pkgpart ) + LEFT OUTER JOIN cust_pkg USING ( pkgnum ) + LEFT OUTER JOIN part_pkg USING ( pkgpart ) WHERE _date >= $beginning AND _date <= $ending AND ( county = ? OR ? = '' ) AND ( state = ? OR ? = '' ) |