diff options
| -rw-r--r-- | FS/FS/cust_bill.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm index f673b76a3..9f27a74ba 100644 --- a/FS/FS/cust_bill.pm +++ b/FS/FS/cust_bill.pm @@ -681,8 +681,8 @@ sub cust_bill_pay_pkg { qsearch({ 'select' => 'cust_bill_pay_pkg.*', 'table' => 'cust_bill_pay_pkg', - 'addl_from' => ' LEFT JOIN cust_bill_pay USING billpaynum '. - ' LEFT JOIN cust_bill_pkg USING billpkgnum ', + 'addl_from' => ' LEFT JOIN cust_bill_pay USING ( billpaynum ) '. + ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', 'hashref' => { 'invnum' => $self->invnum, 'pkgnum' => $pkgnum, }, @@ -726,8 +726,8 @@ sub cust_credit_bill_pkg { qsearch({ 'select' => 'cust_credit_bill_pkg.*', 'table' => 'cust_credit_bill_pkg', - 'addl_from' => ' LEFT JOIN cust_credit_bill USING creditbillnum '. - ' LEFT JOIN cust_bill_pkg USING billpkgnum ', + 'addl_from' => ' LEFT JOIN cust_credit_bill USING ( creditbillnum ) '. + ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', 'hashref' => { 'invnum' => $self->invnum, 'pkgnum' => $pkgnum, }, |