X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_svc.html;h=9cf4bbda6196ba2b17af66e3071a858d02d102c3;hb=c4b71bc4459cb7d403cbebede470aeb2c6292a6e;hp=72ecb8e356455c5fe25f8c0fac87d67f212b1514;hpb=16c3fc46b67dc42c0404fc93aa54ce61be5f08f9;p=freeside.git

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