X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_timespan.html;h=370b0b6ca5d2d3c334ec2ac80b873d497865eb27;hp=a380b78ab3bacf6db69b00cc0831332ccf1d1542;hb=5153c04218af1627d1e4e7c8216887fa3c54db7c;hpb=08ec0a26405eab73e9fe80632e788d9af4c76fe7

diff --git a/httemplate/search/cust_timespan.html b/httemplate/search/cust_timespan.html
index a380b78ab..370b0b6ca 100644
--- a/httemplate/search/cust_timespan.html
+++ b/httemplate/search/cust_timespan.html
@@ -72,7 +72,7 @@ my $email_sub = sub {
   #can't because contactnum is in the wrong field #my @contact_email = $contact->contact_email;
   my @contact_email = qsearch({
 	table => 'contact_email',
-	addl_from => ' LEFT JOIN cust_contact ON (contact_email.contactnum = cust_contact.contactnum) LEFT JOIN cust_main ON (cust_contact.custnum = cust_main.custnum) ',
+	addl_from => ' LEFT JOIN contact ON (contact_email.contactnum = contact.contactnum) LEFT JOIN cust_main ON (contact.custnum = cust_main.custnum) ',
 	extra_sql => ' WHERE cust_main.custnum = ' . $customer->custnum ,
   } );
   join('<br>', map $_->emailaddress, @contact_email);