diff options
| author | ivan <ivan> | 2010-04-07 04:11:14 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2010-04-07 04:11:14 +0000 |
| commit | 009a2b6cff2ad3bfb3c65ad9ac15a1d612606ac9 (patch) | |
| tree | c3eb90873b122ab5e71c076e9738269284c4beda | |
| parent | e43a91663fe211df6e0bf4c60b7ee65ad5b6d667 (diff) | |
fix a mysql-ism in employee commission report, now compatible with Pg, that's a new one. RT#6991
| -rw-r--r-- | httemplate/search/part_pkg.html | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/part_pkg.html b/httemplate/search/part_pkg.html index 87237c7cf..30b541986 100644 --- a/httemplate/search/part_pkg.html +++ b/httemplate/search/part_pkg.html @@ -114,8 +114,8 @@ if (1) { #commission reports } my $from_cust_bill_pkg_where = "FROM cust_bill_pkg - LEFT JOIN ( cust_bill ) USING ( invnum ) - LEFT JOIN ( cust_pkg ) USING ( pkgnum ) + LEFT JOIN cust_bill USING ( invnum ) + LEFT JOIN cust_pkg USING ( pkgnum ) WHERE cust_bill_pkg.pkgnum > 0 AND cust_bill._date >= $beginning AND cust_bill._date <= $ending "; |