CREATE VIEW CourierData AS
SELECT Package.ID_courier, Package.ID, Package.ID_client, Package.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, (Data r JOIN Address ra ON r.ID_address = ra.ID)
WHERE Package.ID_receiver = r.ID