ALTER VIEW clients_view (
 id,
 company_name,
 industry_id,
 country_id,
 city,
 situation,
 contact_name,
 gender,
 position,
 payment_method,
 discount,
 due_days,
 potential_id,
 client_type_id,
 lead_source,
 notes,
 photo
) as
SELECT  t1.id,
        t1.name,
        t1.industry_id,
        t1.country_id,
        t1.city,
        t1.situation,
        CONCAT(t2.first_name, ' ', t2.last_name),
        t2.gender,
        t2.position,
        t1.payment_method,
        t1.discount,
        t1.due_days,
        t1.potential_id,
        t1.client_type_id,
        t1.lead_source,
        t1.notes,
        t1.photo

  FROM  `clients` as t1
  JOIN `client_contacts`     as t2 on t2.client_id = t1.id
;