a guest Dec 16th, 2018 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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
RAW Paste Data