diff options
Diffstat (limited to 'httemplate')
| -rw-r--r-- | httemplate/search/cust_svc.html | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html index 72ecb8e35..9cf4bbda6 100644 --- a/httemplate/search/cust_svc.html +++ b/httemplate/search/cust_svc.html @@ -75,6 +75,7 @@ if ( length( $cgi->param('search_svc') ) ) { $cgi->param('svcdb') =~ /^(svc_\w+)$/ or die "unknown svcdb"; push @extra_sql, "svcdb = '$1'"; + $addl_from .= " LEFT JOIN $1 USING ( svcnum ) "; push @extra_sql, 'pkgnum IS NULL' if $cgi->param('magic') eq 'unlinked'; |