Adding one record from master-table in addition to other records from detail-table to a MySQL-View
CREATE VIEW v_Customers_Contacts
AS

SELECT a.Matchcode as Company
     , b.FirstName
     , b.SecondName
     , b.Phone
     , b.Email
FROM Customers          as a
JOIN Customers_Contacts as b ON b.ID_Customer = a.ID

UNION

SELECT Matchcode as Company
     , NULL      as FirstName
     , NULL      as SecondName
     , Phone
     , Email
FROM Customers ;


When selecting from the view:

SELECT Company
     , FirstName
     , SecondName
     , Phone
     , Email
FROM v_Customers_Contacts
ORDER BY Company, SecondName, FirstName ;