diff options
| author | ivan <ivan> | 2004-10-25 21:35:33 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-10-25 21:35:33 +0000 |
| commit | 58d1b576fda1ebd3d6f7f1bfd20575d4597c7159 (patch) | |
| tree | 0e7f4a239a9b1c41f18047e2796e70bd956ae07a | |
| parent | 3aee44000261cb8590beed291d518d103ce0d33e (diff) | |
fix joins for proper tax reporting
| -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 ? = '' ) |