# setup queries, subs, etc. for the search
##
- $orderby ||= 'ORDER BY custnum';
+ $orderby ||= 'ORDER BY cust_main.custnum';
# here is the agent virtualization
push @where,
}
- # set select a customer only once. some joins create multiple customer records.
- my $select = 'DISTINCT ON (cust_main.custnum) ' . join(', ', @select);
+ my $select = join(', ', @select);
my $sql_query = {
'table' => 'cust_main',