CREATE VIEW ClientHistory
AS
SELECT
p.ID, p.Location,
p.ID_client,
p.TelephoneNumber,
s.FirstName AS 'senderFirstName',
 s.LastName AS 'SenderLastName',
sa.City AS 'SenderCity',
sa.PostCode AS 'SenderPostCode',
sa.Street AS 'SenderStreet',
sa.HouseNumber AS 'SenderHouseNumber',
sa.ApartmentNumber AS 'SenderApartmentNumber',
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 s
ON p.ID_sender = s.ID
JOIN Address sa
ON s.ID_address = sa.ID,
Package p2
JOIN Data r
ON p2.ID_receiver = r.ID
JOIN Address ra
ON r.ID_address = ra.ID