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,
},
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,
},