From 7c17ae7d898fcbaa1b95c821b72b2250e02a0f3b Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 25 Oct 2004 21:35:32 +0000
Subject: fix joins for proper tax reporting

---
 httemplate/search/report_tax.cgi | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'httemplate/search/report_tax.cgi')

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 ? = '' )
-- 
cgit v1.2.1