CREATE VIEW CourierData
     AS SELECT
    p.ID_courier,
    p.ID, p.ID_client,
    p.TelephoneNumber,
    r.FirstName AS 'ReceiverFirstName',
    r.LastName AS 'ReceiverLastName',
    ra.City AS 'ReceiverCity',
    ra.PostCode AS 'ReceiverPostCode',
    ra.Street AS 'ReceiverStreet',
    ra.HouseNumber AS 'ReceiverHouseNumber',
    ra.ApartmentNumber AS 'ReceiverApartmentNumber'
    FROM Package p
    JOIN Data r
    ON p.ID_receiver = r.ID
    JOIN Address ra
    ON r.ID_address = ra.ID