From cdd6f558ad683955af4ab1a3fa6e3c4060241d9d Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 7 Apr 2010 04:11:13 +0000
Subject: [PATCH] fix a mysql-ism in employee commission report, now compatible
 with Pg, that's a new one.  RT#6991

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

diff --git a/httemplate/search/part_pkg.html b/httemplate/search/part_pkg.html
index c6c05b873..915dbf448 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         ";
-- 
2.11.0