X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/16c66f611b987008d72c4475ce7cf691d517af0f..e09347c89ca119213c4d8ba43083653cda793399:/SL/Common.pm diff --git a/SL/Common.pm b/SL/Common.pm index b5e231c7b..bdc4c5dd6 100644 --- a/SL/Common.pm +++ b/SL/Common.pm @@ -194,7 +194,7 @@ sub retrieve_customers_or_vendors { push(@queries, qq|SELECT c.id, c.name, 0 AS customer_is_vendor, c.street, c.zipcode, c.city, - ct.cp_greeting, ct.cp_title, ct.cp_givenname, ct.cp_name + ct.cp_gender, ct.cp_title, ct.cp_givenname, ct.cp_name FROM customer c LEFT JOIN contacts ct ON (c.id = ct.cp_cv_id) $c_filter|); @@ -207,7 +207,7 @@ sub retrieve_customers_or_vendors { push(@queries, qq|SELECT v.id, v.name, 1 AS customer_is_vendor, v.street, v.zipcode, v.city, - ct.cp_greeting, ct.cp_title, ct.cp_givenname, ct.cp_name + ct.cp_gender, ct.cp_title, ct.cp_givenname, ct.cp_name FROM vendor v LEFT JOIN contacts ct ON (v.id = ct.cp_cv_id) $v_filter|);