diff options
| -rw-r--r-- | httemplate/search/cust_timespan.html | 2 |
1 files changed, 1 insertions, 1 deletions
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); |