X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fpart_pkg.html;h=915dbf4482f56509aead0c5ee874c09f2c70a7d3;hb=636dd1f25af52d35efe7a323a5765ff5adeadf83;hp=c6c05b873f542d27d32a68173576c7b469a52cb0;hpb=7ab23ad39e05768c8da8cb419b9d88fee052684f;p=freeside.git

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         ";