diff options
| author | ivan <ivan> | 2004-10-25 21:35:32 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-10-25 21:35:32 +0000 |
| commit | 7c17ae7d898fcbaa1b95c821b72b2250e02a0f3b (patch) | |
| tree | 79f7ae92bbeb4a11e17159f5f918ccdff4a54f5b /httemplate/search/report_tax.cgi | |
| parent | 7dffaeef2be777b6ef04e24256744c690e55c398 (diff) | |
fix joins for proper tax reporting
Diffstat (limited to 'httemplate/search/report_tax.cgi')
| -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 ? = '' ) |